DBA Data[Home] [Help]

APPS.PQH_PQIPED11_XMLP_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 292: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

288: HR_LOOKUPS HL
289: WHERE PEO.PERSON_ID = ASS.PERSON_ID
290: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
291: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
292: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
293: ,CP_FR
294: ,CP_FT
295: ,CP_PR
296: ,CP_PT) IN ( 'PR' )

Line 470: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

466: FROM
467: PER_PEOPLE_EXTRA_INFO PEI3
468: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
469: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
470: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
471: ,CP_FR
472: ,CP_FT
473: ,CP_PR
474: ,CP_PT) IN ( 'PR' )

Line 677: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

673: HR_LOOKUPS HL
674: WHERE PEO.PERSON_ID = ASS.PERSON_ID
675: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
676: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
677: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
678: ,CP_FR
679: ,CP_FT
680: ,CP_PR
681: ,CP_PT) IN ( 'PR' )

Line 853: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

849: FROM
850: PER_PEOPLE_EXTRA_INFO PEI3
851: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
852: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
853: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
854: ,CP_FR
855: ,CP_FT
856: ,CP_PR
857: ,CP_PT) IN ( 'PR' )

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

888:
889: begin
890: --hr_standard.event('BEFORE REPORT');
891:
892: pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);
893:
894: cp_fr := l_fr;
895: cp_ft := l_ft;
896: cp_pr := l_pr;