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 840: ,pay_element_entries_f pee

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

Line 1612: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;

1608: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1609: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1610: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1611: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1612: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1613: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1614: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1615: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1616: l_proposal_date_to per_pay_Proposals.date_to%type; -- bug 6856664

Line 1613: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;

1609: L_DFLT_INPUT_VALUE_ID Ben_Pgm_F.DFLT_INPUT_VALUE_ID%TYPE;
1610: L_DFLT_ELEMENT_TYPE_ID Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1611: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1612: L_Element_Entry_ID pay_element_entries_f.Element_Entry_Id%TYPE;
1613: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%TYPE;
1614: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;
1615: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1616: l_proposal_date_to per_pay_Proposals.date_to%type; -- bug 6856664
1617:

Line 1638: ,pay_element_entries_f pee

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

Line 1712: from pay_element_entries_f

1708: and Assignment_id = P_Assignment_id;
1709: --
1710: cursor csr_prev_sp_element is
1711: select element_entry_id
1712: from pay_element_entries_f
1713: where assignment_id = p_assignment_id
1714: and creator_type = 'SP'
1715: and l_prev_sal_change_dt between
1716: effective_start_date and effective_end_date;

Line 1805: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'

1801: /**
1802: -- End date element entry.
1803: L_DATE_TRACK_MODE := DT_del_Mode
1804: (P_EFFECTIVE_DATE => p_current_rate_change_dt
1805: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
1806: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
1807: ,P_BASE_KEY_VALUE => L_Element_Entry_ID);
1808: --
1809: hr_entry_api.delete_element_entry

Line 1955: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

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

Line 1956: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%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;
1959: l_Create_Warn Boolean;
1960: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 1957: L_Element_Entry_ID pay_element_entries_f.Element_Entry_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;
1959: l_Create_Warn Boolean;
1960: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1961: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;

Line 1958: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%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;
1959: l_Create_Warn Boolean;
1960: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1961: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
1962: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

Line 1989: pay_element_entries_f ele,

1985:
1986: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
1987: Select ele.element_entry_id
1988: from per_pay_bases bas,
1989: pay_element_entries_f ele,
1990: pay_element_entry_values_f entval
1991: where bas.pay_basis_id = P_pay_basis_id
1992: and entval.input_value_id = bas.input_value_id
1993: and p_effective_date

Line 2013: ,pay_element_entries_f pee

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

Line 2218: from pay_element_entries_f

2214:
2215: --
2216:
2217: select max(effective_end_date) into L_entry_date
2218: from pay_element_entries_f
2219: where assignment_id=L_Enroll_Info.Assignment_Id
2220: and creator_type='SP';
2221:
2222: hr_utility.set_location(' Max Element entry date: ' ||L_entry_date,1);

Line 2347: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'

2343: If Elmt_Entry%Found Then
2344:
2345: L_DATE_TRACK_MODE := DT_Mode
2346: (P_EFFECTIVE_DATE => L_Enroll_Info.RT_Strt_Dt
2347: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
2348: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
2349: ,P_BASE_KEY_VALUE => L_Element_Entry_ID);
2350: hr_utility.set_location('Sal = '||to_char(L_Salary)||',DT_Mode = '||L_DATE_TRACK_MODE,99);
2351:

Line 3168: ,pay_element_entries_f pee

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

Line 3534: L_Effective_Start_Date pay_element_entries_f.Effective_Start_Date%TYPE;

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

Line 3535: L_Effective_End_Date pay_element_entries_f.Effective_End_Date%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;
3538: l_Create_Warn Boolean;
3539: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;

Line 3536: L_Element_Entry_ID pay_element_entries_f.Element_Entry_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;
3538: l_Create_Warn Boolean;
3539: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3540: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;

Line 3537: L_Ele_Ovn pay_element_entries_f.Object_Version_Number%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;
3538: l_Create_Warn Boolean;
3539: l_DFLT_STEP_CD Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3540: l_Change_Dt Per_Pay_proposals.Change_Date%TYPE;
3541: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_Id%TYPE;

Line 3577: pay_element_entries_f ele,

3573:
3574: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
3575: Select ele.element_entry_id
3576: from per_pay_bases bas,
3577: pay_element_entries_f ele,
3578: pay_element_entry_values_f entval
3579: where bas.pay_basis_id = P_pay_basis_id
3580: and entval.input_value_id = bas.input_value_id
3581: and p_effective_date

Line 3601: ,pay_element_entries_f pee

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

Line 3852: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'

3848: If Elmt_Entry%Found Then
3849:
3850: L_DATE_TRACK_MODE := DT_Mode
3851: (P_EFFECTIVE_DATE => L_Enroll_Info.RT_Strt_Dt
3852: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
3853: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
3854: ,P_BASE_KEY_VALUE => L_Element_Entry_ID);
3855:
3856: Pay_Element_Entry_Api.UPDATE_ELEMENT_ENTRY