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 PER_PAY_PROPOSALS

Line 990: from per_pay_proposals

986:
987:
988: cursor csr_salary (p_asg number, p_efd date) is
989: select proposed_salary_n
990: from per_pay_proposals
991: where assignment_id = p_asg
992: and p_efd between change_date and nvl(date_to , hr_api.g_eot) ;
993:
994:

Line 1614: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_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:
1618: l_del_warn boolean;

Line 1615: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%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:
1618: l_del_warn boolean;
1619: L_DATE_TRACK_MODE Varchar2(25);

Line 1616: l_proposal_date_to per_pay_Proposals.date_to%type; -- bug 6856664

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:
1618: l_del_warn boolean;
1619: L_DATE_TRACK_MODE Varchar2(25);
1620: l_inv_next_sal_date_warning boolean;

Line 1706: From Per_Pay_Proposals

1702: And Elct.ELIG_PER_ELCTBL_CHC_ID = Rate.ELIG_PER_ELCTBL_CHC_ID(+);
1703: --
1704: Cursor Proposal_Dtls (P_Assignment_Id in Number,p_change_dt in date) is
1705: Select Pay_Proposal_Id, Object_Version_Number, nvl(date_to,to_date('31-12-4712','dd-mm-yyyy')) -- bug 6856664
1706: From Per_Pay_Proposals
1707: Where Change_Date = P_Change_Dt
1708: and Assignment_id = P_Assignment_id;
1709: --
1710: cursor csr_prev_sp_element is

Line 1940: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;

1936: And Asgt.assignment_type = 'E'
1937: And P_Effective_Date
1938: Between Asgt.Effective_start_Date and Asgt.Effective_end_Date; */
1939:
1940: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1941: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1942:
1943: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1944: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

Line 1941: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;

1937: And P_Effective_Date
1938: Between Asgt.Effective_start_Date and Asgt.Effective_end_Date; */
1939:
1940: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1941: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1942:
1943: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1944: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
1945: L_INV_NEXT_SAL_DATE_WARNING Boolean;

Line 1961: l_Change_Dt Per_Pay_proposals.Change_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;
1963: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1964:
1965: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;

Line 1962: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_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;
1963: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1964:
1965: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;
1966: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;

Line 1963: l_Del_Proposal_Ovn per_pay_Proposals.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;
1963: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1964:
1965: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;
1966: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
1967:

Line 2030: from Per_Pay_Proposals

2026: and pee.effective_end_date;
2027:
2028: Cursor Proposal_Dt (P_Assignment_Id IN Number) is
2029: Select Max(Change_Date)
2030: from Per_Pay_Proposals
2031: Where Assignment_Id = P_Assignment_id
2032: AND p_Effective_date BETWEEN Change_Date AND
2033: nvl(DATE_TO,to_date('31-12-4712','dd-mm-yyyy')) ;-- added for bug 6880958
2034: -- bug 6880958 modified the above cursor. as the when performing a date track correction

Line 2040: From Per_Pay_Proposals

2036:
2037:
2038: Cursor Proposal_Dtls (P_Assignment_Id in Number) is
2039: Select Pay_Proposal_Id, Object_Version_Number
2040: From Per_Pay_Proposals
2041: Where Change_Date = l_Change_Dt
2042: and Assignment_id = P_Assignment_id;
2043:
2044: L_Enroll_Info Enroll_Info%ROWTYPE;

Line 2052: from per_pay_proposals

2048: --
2049: Cursor next_change_date(P_Assignment_id in number)
2050: IS
2051: select change_date ,Pay_Proposal_Id, Object_Version_Number
2052: from per_pay_proposals
2053: where assignment_id = P_Assignment_id
2054: and change_date > p_Effective_date;
2055:
2056: l_change_date date;

Line 2062: from per_pay_proposals

2058:
2059: cursor csr_count_pay_det(P_Assignment_id in number)
2060: is
2061: select count(*)
2062: from per_pay_proposals
2063: where assignment_id = P_Assignment_id
2064: and change_date > p_Effective_date;
2065: --
2066: l_count number;

Line 2290: ,P_PK_ID_TABLE_NAME => 'PER_PAY_PROPOSALS'

2286:
2287: /*
2288: Ben_Prtt_Rt_Val_Api.UPDATE_PRTT_RT_VAL
2289: (P_PRTT_RT_VAL_ID => L_Enroll_Info.PRTT_RT_VAL_ID
2290: ,P_PK_ID_TABLE_NAME => 'PER_PAY_PROPOSALS'
2291: ,P_PK_ID => l_Pay_Proposal_Id
2292: ,P_OBJECT_VERSION_NUMBER => L_Rt_Ovn
2293: ,P_EFFECTIVE_DATE => P_Effective_Date); */
2294:

Line 2328: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id

2324: End If;
2325: --
2326: -- Get current pay proposal
2327: --
2328: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id
2329: ,L_Enroll_Info.RT_Strt_Dt
2330: ,l_Payroll_name
2331: ,l_payroll_annualization_factor);
2332:

Line 3517: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;

3513:
3514:
3515:
3516:
3517: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3518: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3519: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3520: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3521: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;

Line 3518: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;

3514:
3515:
3516:
3517: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3518: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3519: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3520: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3521: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3522: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

Line 3540: l_Change_Dt Per_Pay_proposals.Change_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;
3542: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3543: l_cur_sal number;
3544: l_per_in_ler_ovn number;

Line 3541: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_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;
3542: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3543: l_cur_sal number;
3544: l_per_in_ler_ovn number;
3545: l_procd_date date;

Line 3542: l_Del_Proposal_Ovn per_pay_Proposals.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;
3542: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3543: l_cur_sal number;
3544: l_per_in_ler_ovn number;
3545: l_procd_date date;
3546: l_strtd_date date;

Line 3618: from Per_Pay_Proposals

3614: and pee.effective_end_date;
3615:
3616: Cursor Proposal_Dt (P_Assignment_Id IN Number) is
3617: Select Max(Change_Date)
3618: from Per_Pay_Proposals
3619: Where Assignment_Id = P_Assignment_id;
3620:
3621: Cursor Proposal_Dtls (P_Assignment_Id in Number) is
3622: Select Pay_Proposal_Id, Object_Version_Number

Line 3623: From Per_Pay_Proposals

3619: Where Assignment_Id = P_Assignment_id;
3620:
3621: Cursor Proposal_Dtls (P_Assignment_Id in Number) is
3622: Select Pay_Proposal_Id, Object_Version_Number
3623: From Per_Pay_Proposals
3624: Where Change_Date = l_Change_Dt
3625: and Assignment_id = P_Assignment_id;
3626:
3627: Cursor pay_basis_frequency (p_pay_basis_id in number)is

Line 3836: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id

3832: fnd_message.raise_error;
3833: End If;
3834:
3835:
3836: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id
3837: ,L_Enroll_Info.RT_Strt_Dt
3838: ,l_Payroll_name
3839: ,l_payroll_annualization_factor);
3840: