APPS.PQH_GSP_POST_PROCESS dependencies on PAY_ELEMENT_TYPES_F

Line 838: from pay_element_types_f pet

834: and Effective_End_Date;
835:
836: CURSOR Elmt_Asgmnt_link (P_Element_Type_Id IN NUMBER) IS
837: select 'Y'
838: from pay_element_types_f pet
839: ,pay_element_links_f pel
840: ,pay_element_entries_f pee
841: where Pet.Element_type_id = P_Element_type_Id
842: and p_Effective_date

Line 1636: from pay_element_types_f pet

1632:
1633: --
1634: CURSOR Elmt_Entry (p_assignment_id IN NUMBER, P_Business_group_Id IN Number, p_Effective_Date IN Date) IS
1635: select pee.Element_Entry_Id, pee.Object_version_Number
1636: from pay_element_types_f pet
1637: ,pay_element_links_f pel
1638: ,pay_element_entries_f pee
1639: where Pet.Element_type_id = L_DFLT_ELEMENT_TYPE_ID
1640: and p_Effective_date

Line 2011: from pay_element_types_f pet

2007: and Effective_End_Date;
2008:
2009: CURSOR Elmt_Entry (p_assignment_id IN NUMBER, P_Business_group_Id IN Number, p_Effective_Date IN Date) IS
2010: select pee.Element_Entry_Id, pee.Object_version_Number
2011: from pay_element_types_f pet
2012: ,pay_element_links_f pel
2013: ,pay_element_entries_f pee
2014: where Pet.Element_type_id = L_DFLT_ELEMENT_TYPE_ID
2015: and p_Effective_date

Line 3166: from pay_element_types_f pet

3162:
3163:
3164: CURSOR Elmt_Asgmnt_link (P_Element_Type_Id IN NUMBER) IS
3165: select 'Y'
3166: from pay_element_types_f pet
3167: ,pay_element_links_f pel
3168: ,pay_element_entries_f pee
3169: where Pet.Element_type_id = P_Element_type_Id
3170: and p_Effective_date

Line 3599: from pay_element_types_f pet

3595: and Effective_End_Date;
3596:
3597: CURSOR Elmt_Entry (p_assignment_id IN NUMBER, P_Business_group_Id IN Number, p_Effective_Date IN Date) IS
3598: select pee.Element_Entry_Id, pee.Object_version_Number
3599: from pay_element_types_f pet
3600: ,pay_element_links_f pel
3601: ,pay_element_entries_f pee
3602: where Pet.Element_type_id = L_DFLT_ELEMENT_TYPE_ID
3603: and p_Effective_date