APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 769: from pay_element_classifications

765: RETURN NUMBER IS
766:
767: cursor curs is
768: select classification_id
769: from pay_element_classifications
770: where classification_name in ('Employer Liabilities', 'Earnings','Supplemental Earnings')
771: and legislation_code = p_legislation_code;
772:
773: cl_id number;

Line 799: from pay_element_classifications

795: WHERE RES.ASSIGNMENT_ACTION_ID = aa.assignment_action_id
796: AND RES.STATUS IN ( 'P','PA' )
797: AND PET.CLASSIFICATION_ID in (
798: select classification_id
799: from pay_element_classifications
800: where classification_name in ('Employer Liabilities', 'Earnings','Supplemental Earnings')
801: and legislation_code = 'US'
802: )
803: AND PET.ELEMENT_TYPE_ID = p_element_type_id

Line 837: from pay_element_classifications

833: WHERE RES.ASSIGNMENT_ACTION_ID = aa.assignment_action_id
834: AND RES.STATUS IN ( 'P','PA' )
835: AND PET.CLASSIFICATION_ID in (
836: select classification_id
837: from pay_element_classifications
838: where classification_name in ('Employer Liabilities', 'Earnings','Supplemental Earnings')
839: and legislation_code = 'US' )
840: AND aa.start_date BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE
841: AND PET.ELEMENT_TYPE_ID = RES.ELEMENT_TYPE_ID

Line 1269: from pay_element_classifications

1265: -- This cursor will find the classification ids.
1266: --
1267: cursor curs is
1268: select classification_id
1269: from pay_element_classifications
1270: where classification_name in ('Employer Liabilities', 'Earnings','Supplemental Earnings')
1271: and legislation_code = p_legislation_code;
1272: cl_id number;
1273:

Line 4094: from pay_element_classifications,

4090: --
4091: --
4092: cursor curs1(p_position_id number, p_actuals_start_date date) is
4093: select classification_id
4094: from pay_element_classifications,
4095: hr_all_positions_f pos,
4096: HR_ORGANIZATION_INFORMATION O3
4097: where classification_name in ('Earnings', 'Employer Liabilities')
4098: and legislation_code = O3.ORG_INFORMATION9