APPS.PQH_GSP_POST_PROCESS dependencies on PAY_ELEMENT_TYPES_F

Line 797: from pay_element_types_f pet

793: and Effective_End_Date;
794:
795: CURSOR Elmt_Asgmnt_link (P_Element_Type_Id IN NUMBER) IS
796: select 'Y'
797: from pay_element_types_f pet
798: ,pay_element_links_f pel
799: ,pay_element_entries_f pee
800: where Pet.Element_type_id = P_Element_type_Id
801: and p_Effective_date

Line 1476: from pay_element_types_f pet

1472:
1473: --
1474: CURSOR Elmt_Entry (p_assignment_id IN NUMBER, P_Business_group_Id IN Number, p_Effective_Date IN Date) IS
1475: select pee.Element_Entry_Id, pee.Object_version_Number
1476: from pay_element_types_f pet
1477: ,pay_element_links_f pel
1478: ,pay_element_entries_f pee
1479: where Pet.Element_type_id = L_DFLT_ELEMENT_TYPE_ID
1480: and p_Effective_date

Line 1851: from pay_element_types_f pet

1847: and Effective_End_Date;
1848:
1849: CURSOR Elmt_Entry (p_assignment_id IN NUMBER, P_Business_group_Id IN Number, p_Effective_Date IN Date) IS
1850: select pee.Element_Entry_Id, pee.Object_version_Number
1851: from pay_element_types_f pet
1852: ,pay_element_links_f pel
1853: ,pay_element_entries_f pee
1854: where Pet.Element_type_id = L_DFLT_ELEMENT_TYPE_ID
1855: and p_Effective_date

Line 3006: from pay_element_types_f pet

3002:
3003:
3004: CURSOR Elmt_Asgmnt_link (P_Element_Type_Id IN NUMBER) IS
3005: select 'Y'
3006: from pay_element_types_f pet
3007: ,pay_element_links_f pel
3008: ,pay_element_entries_f pee
3009: where Pet.Element_type_id = P_Element_type_Id
3010: and p_Effective_date

Line 3439: from pay_element_types_f pet

3435: and Effective_End_Date;
3436:
3437: CURSOR Elmt_Entry (p_assignment_id IN NUMBER, P_Business_group_Id IN Number, p_Effective_Date IN Date) IS
3438: select pee.Element_Entry_Id, pee.Object_version_Number
3439: from pay_element_types_f pet
3440: ,pay_element_links_f pel
3441: ,pay_element_entries_f pee
3442: where Pet.Element_type_id = L_DFLT_ELEMENT_TYPE_ID
3443: and p_Effective_date