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_ENTRIES_F

Line 799: ,pay_element_entries_f pee

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
803: and pet.effective_end_date

Line 1452: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;

1448: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1449: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1450: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1451: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1452: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1453: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1454: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1455: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1456: l_proposal_date_to per_pay_Proposals.date_to%type; -- bug 6856664

Line 1453: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

1449: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1450: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1451: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1452: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1453: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1454: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1455: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1456: l_proposal_date_to per_pay_Proposals.date_to%type; -- bug 6856664
1457:

Line 1478: ,pay_element_entries_f pee

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
1482: and pet.effective_end_date

Line 1552: from pay_element_entries_f

1548: and Assignment_id = P_Assignment_id;
1549: --
1550: cursor csr_prev_sp_element is
1551: select element_entry_id
1552: from pay_element_entries_f
1553: where assignment_id = p_assignment_id
1554: and creator_type = 'SP'
1555: and l_prev_sal_change_dt between
1556: effective_start_date and effective_end_date;

Line 1645: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'

1641: /**
1642: -- End date element entry.
1643: L_DATE_TRACK_MODE := DT_del_Mode
1644: (P_EFFECTIVE_DATE => p_current_rate_change_dt
1645: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
1646: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
1647: ,P_BASE_KEY_VALUE => L_Element_Entry_ID);
1648: --
1649: hr_entry_api.delete_element_entry

Line 1795: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

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;
1799: l_Create_Warn Boolean;

Line 1796: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%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;
1799: l_Create_Warn Boolean;
1800: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 1797: L_Element_Entry_ID pay_element_entries_f.Element_Entry_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;
1799: l_Create_Warn Boolean;
1800: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1801: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;

Line 1798: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%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;
1799: l_Create_Warn Boolean;
1800: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1801: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
1802: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

Line 1829: pay_element_entries_f ele,

1825:
1826: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
1827: Select ele.element_entry_id
1828: from per_pay_bases bas,
1829: pay_element_entries_f ele,
1830: pay_element_entry_values_f entval
1831: where bas.pay_basis_id = P_pay_basis_id
1832: and entval.input_value_id = bas.input_value_id
1833: and p_effective_date

Line 1853: ,pay_element_entries_f pee

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
1857: and pet.effective_end_date

Line 2058: from pay_element_entries_f

2054:
2055: --
2056:
2057: select max(effective_end_date) into L_entry_date
2058: from pay_element_entries_f
2059: where assignment_id=L_Enroll_Info.Assignment_Id
2060: and creator_type='SP';
2061:
2062: hr_utility.set_location(' Max Element entry date: ' ||L_entry_date,1);

Line 2187: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'

2183: If Elmt_Entry%Found Then
2184:
2185: L_DATE_TRACK_MODE := DT_Mode
2186: (P_EFFECTIVE_DATE => L_Enroll_Info.RT_Strt_Dt
2187: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
2188: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
2189: ,P_BASE_KEY_VALUE => L_Element_Entry_ID);
2190: hr_utility.set_location('Sal = '||to_char(L_Salary)||',DT_Mode = '||L_DATE_TRACK_MODE,99);
2191:

Line 3008: ,pay_element_entries_f pee

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
3012: and pet.effective_end_date

Line 3374: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

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;
3378: l_Create_Warn Boolean;

Line 3375: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%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;
3378: l_Create_Warn Boolean;
3379: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 3376: L_Element_Entry_ID pay_element_entries_f.Element_Entry_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;
3378: l_Create_Warn Boolean;
3379: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3380: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;

Line 3377: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%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;
3378: l_Create_Warn Boolean;
3379: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3380: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
3381: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

Line 3417: pay_element_entries_f ele,

3413:
3414: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
3415: Select ele.element_entry_id
3416: from per_pay_bases bas,
3417: pay_element_entries_f ele,
3418: pay_element_entry_values_f entval
3419: where bas.pay_basis_id = P_pay_basis_id
3420: and entval.input_value_id = bas.input_value_id
3421: and p_effective_date

Line 3441: ,pay_element_entries_f pee

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
3445: and pet.effective_end_date

Line 3692: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'

3688: If Elmt_Entry%Found Then
3689:
3690: L_DATE_TRACK_MODE := DT_Mode
3691: (P_EFFECTIVE_DATE => L_Enroll_Info.RT_Strt_Dt
3692: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
3693: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
3694: ,P_BASE_KEY_VALUE => L_Element_Entry_ID);
3695:
3696: Pay_Element_Entry_Api.UPDATE_ELEMENT_ENTRY