APPS.PQH_PQIPED7_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

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

200: HR_LOOKUPS HL
201: WHERE PEO.PERSON_ID = ASS.PERSON_ID
202: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
203: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
204: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
205: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
206: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
207: AND HL.LOOKUP_CODE IN('1', '2', '3')
208: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

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

270: FROM PER_PEOPLE_EXTRA_INFO PEI3
271: WHERE PEI3.PERSON_ID = PEI.PERSON_ID))
272: )
273: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
274: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
275: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
276: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
277: AND HL.LOOKUP_CODE IN('1', '2', '3')
278: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

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

352: HR_LOOKUPS HL
353: WHERE PEO.PERSON_ID = ASS.PERSON_ID
354: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
355: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
356: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
357: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
358: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
359: AND HL.LOOKUP_CODE NOT IN('1', '2', '3')
360: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

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

424: FROM PER_PEOPLE_EXTRA_INFO PEI3
425: WHERE PEI3.PERSON_ID = PEI.PERSON_ID))
426: )
427: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
428: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')
429: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
430: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
431: AND HL.LOOKUP_CODE NOT IN('1', '2', '3')
432: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

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

456:
457: begin
458: --hr_standard.event('BEFORE REPORT');
459: LP_REPORT_DATE := to_char(P_REPORT_DATE,'DD-MON-YYYY');
460: pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);
461:
462: cp_fr := l_fr;
463: cp_ft := l_ft;
464: cp_pr := l_pr;