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 798: ,pay_element_links_f pel

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

Line 953: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

949: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
950: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;
951: l_start_date ben_yr_perd.start_date%TYPE;
952: l_end_date ben_yr_perd.end_date%TYPE;
953: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
954: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
955: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
956: l_New_Enrlmt_Dt Date;
957: l_max_lf_evt_date Date;

Line 1477: ,pay_element_links_f pel

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

Line 1794: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

1790: L_ERROR_TEXT Varchar2(250);
1791: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1792: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1793: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1794: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
1795: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
1796: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
1797: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1798: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

Line 1852: ,pay_element_links_f pel

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

Line 3007: ,pay_element_links_f pel

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

Line 3094: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

3090: l_yr_perd_id ben_popl_yr_perd.yr_perd_id%TYPE;
3091: L_popl_yr_perd_id ben_popl_yr_perd.popl_yr_perd_id%TYPE;
3092: l_start_date ben_yr_perd.start_date%TYPE;
3093: l_end_date ben_yr_perd.end_date%TYPE;
3094: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3095: l_Curr_Pl_Id Ben_Pl_F.Pl_Id%TYPE;
3096: l_Curr_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
3097:
3098:

Line 3373: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;

3369: L_ERROR_TEXT Varchar2(250);
3370: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3371: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
3372: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3373: l_Element_Link_Id Pay_Element_Links_f.Element_Link_Id%TYPE;
3374: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;
3375: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%TYPE;
3376: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
3377: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

Line 3440: ,pay_element_links_f pel

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