APPS.PQH_PQIPED7_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 149: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

145: HR_LOOKUPS HL
146: WHERE PEO.PERSON_ID = ASS.PERSON_ID
147: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
148: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
149: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
150: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
151: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
152: AND HL.LOOKUP_CODE IN('1', '2', '3')
153: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

Line 217: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

213: FROM PER_PEOPLE_EXTRA_INFO PEI3
214: WHERE PEI3.PERSON_ID = PEI.PERSON_ID))
215: )
216: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
217: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
218: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
219: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
220: AND HL.LOOKUP_CODE IN('1', '2', '3')
221: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

Line 271: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

267: HR_LOOKUPS HL
268: WHERE PEO.PERSON_ID = ASS.PERSON_ID
269: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
270: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
271: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
272: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
273: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
274: AND HL.LOOKUP_CODE NOT IN('1', '2', '3')
275: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

Line 339: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

335: FROM PER_PEOPLE_EXTRA_INFO PEI3
336: WHERE PEI3.PERSON_ID = PEI.PERSON_ID))
337: )
338: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
339: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
340: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
341: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
342: AND HL.LOOKUP_CODE NOT IN('1', '2', '3')
343: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

Line 370: pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);

366:
367: begin
368: --hr_standard.event('BEFORE REPORT');
369: LP_REPORT_DATE := to_char(P_REPORT_DATE,'DD-MON-YYYY');
370: pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);
371:
372: cp_fr := l_fr;
373: cp_ft := l_ft;
374: cp_pr := l_pr;