eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_POST_PROCESS dependencies on PAY_ELEMENT_LINKS_F

Line 839: ,pay_element_links_f pel

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
843: Between pet.effective_start_date

Line 1054: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

1050: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
1051: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;
1052: l_start_date ben_yr_perd.start_date%TYPE;
1053: l_end_date ben_yr_perd.end_date%TYPE;
1054: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1055: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
1056: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
1057: l_New_Enrlmt_Dt Date;
1058: l_max_lf_evt_date Date;

Line 1637: ,pay_element_links_f pel

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
1641: Between pet.effective_start_date

Line 1954: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

1950: L_ERROR_TEXT Varchar2(250);
1951: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1952: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1953: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1954: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1955: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
1956: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
1957: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1958: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

Line 2012: ,pay_element_links_f pel

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
2016: Between pet.effective_start_date

Line 3167: ,pay_element_links_f pel

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
3171: Between pet.effective_start_date

Line 3254: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

3250: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
3251: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;
3252: l_start_date ben_yr_perd.start_date%TYPE;
3253: l_end_date ben_yr_perd.end_date%TYPE;
3254: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3255: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3256: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3257:
3258:

Line 3533: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

3529: L_ERROR_TEXT Varchar2(250);
3530: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3531: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3532: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3533: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3534: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
3535: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
3536: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
3537: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

Line 3600: ,pay_element_links_f pel

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
3604: Between pet.effective_start_date