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 1272: from pay_element_classifications

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

Line 4097: from pay_element_classifications,

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