PA Job Listing
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Job Listing (XML)
Short Name: PAXPEJOB_XML
DB package: PA_PAXPEJOB_XMLP_PKG
Source: IMP: Job Listing (XML)
Short Name: PAXPEJOB_XML
DB package: PA_PAXPEJOB_XMLP_PKG
SELECT decode(:p_sort_by, 'JOB LEVEL', jd.segment1, 'JOB DISCIPLINE', jd.segment2, j.name) sort_by_value, jd.segment1 job_level, jd.segment2 job_discipline, j.name, j.comments, j.date_from, j.date_to FROM per_jobs j, per_job_definitions jd, pa_implementations pi WHERE j.business_group_id = pi.business_group_id and j.job_definition_id = jd.job_definition_id and nvl ( jd.segment1 , 'zzz' ) = nvl ( :p_job_level , nvl ( jd.segment1 , 'zzz' ) ) and nvl ( jd.segment2 , 'zzz' ) = nvl ( :p_job_discipline , nvl ( jd.segment2 , 'zzz' ) ) ORDER BY 1 ASC,2 ASC , j.name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Sort Jobs By |
|
LOV Oracle | |
Job Level |
|
LOV Oracle | |
Job Discipline |
|
LOV Oracle |