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 1454: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_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:
1458: l_del_warn boolean;

Line 1455: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%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:
1458: l_del_warn boolean;
1459: L_DATE_TRACK_MODE Varchar2(25);

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

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:
1458: l_del_warn boolean;
1459: L_DATE_TRACK_MODE Varchar2(25);
1460: l_inv_next_sal_date_warning boolean;

Line 1546: From Per_Pay_Proposals

1542: And Elct.ELIG_PER_ELCTBL_CHC_ID = Rate.ELIG_PER_ELCTBL_CHC_ID(+);
1543: --
1544: Cursor Proposal_Dtls (P_Assignment_Id in Number,p_change_dt in date) is
1545: Select Pay_Proposal_Id, Object_Version_Number, nvl(date_to,to_date('31-12-4712','dd-mm-yyyy')) -- bug 6856664
1546: From Per_Pay_Proposals
1547: Where Change_Date = P_Change_Dt
1548: and Assignment_id = P_Assignment_id;
1549: --
1550: cursor csr_prev_sp_element is

Line 1780: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;

1776: And Asgt.assignment_type = 'E'
1777: And P_Effective_Date
1778: Between Asgt.Effective_start_Date and Asgt.Effective_end_Date; */
1779:
1780: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1781: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1782:
1783: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1784: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

Line 1781: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;

1777: And P_Effective_Date
1778: Between Asgt.Effective_start_Date and Asgt.Effective_end_Date; */
1779:
1780: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
1781: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
1782:
1783: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
1784: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
1785: L_INV_NEXT_SAL_DATE_WARNING Boolean;

Line 1801: l_Change_Dt Per_Pay_proposals.Change_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;
1803: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1804:
1805: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;

Line 1802: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_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;
1803: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1804:
1805: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;
1806: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;

Line 1803: l_Del_Proposal_Ovn per_pay_Proposals.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;
1803: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
1804:
1805: l_payroll_annualization_factor per_time_period_types.number_per_fiscal_year%TYPE;
1806: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
1807:

Line 1870: from Per_Pay_Proposals

1866: and pee.effective_end_date;
1867:
1868: Cursor Proposal_Dt (P_Assignment_Id IN Number) is
1869: Select Max(Change_Date)
1870: from Per_Pay_Proposals
1871: Where Assignment_Id = P_Assignment_id
1872: AND p_Effective_date BETWEEN Change_Date AND
1873: nvl(DATE_TO,to_date('31-12-4712','dd-mm-yyyy')) ;-- added for bug 6880958
1874: -- bug 6880958 modified the above cursor. as the when performing a date track correction

Line 1880: From Per_Pay_Proposals

1876:
1877:
1878: Cursor Proposal_Dtls (P_Assignment_Id in Number) is
1879: Select Pay_Proposal_Id, Object_Version_Number
1880: From Per_Pay_Proposals
1881: Where Change_Date = l_Change_Dt
1882: and Assignment_id = P_Assignment_id;
1883:
1884: L_Enroll_Info Enroll_Info%ROWTYPE;

Line 1892: from per_pay_proposals

1888: --
1889: Cursor next_change_date(P_Assignment_id in number)
1890: IS
1891: select change_date ,Pay_Proposal_Id, Object_Version_Number
1892: from per_pay_proposals
1893: where assignment_id = P_Assignment_id
1894: and change_date > p_Effective_date;
1895:
1896: l_change_date date;

Line 1902: from per_pay_proposals

1898:
1899: cursor csr_count_pay_det(P_Assignment_id in number)
1900: is
1901: select count(*)
1902: from per_pay_proposals
1903: where assignment_id = P_Assignment_id
1904: and change_date > p_Effective_date;
1905: --
1906: l_count number;

Line 2130: ,P_PK_ID_TABLE_NAME => 'PER_PAY_PROPOSALS'

2126:
2127: /*
2128: Ben_Prtt_Rt_Val_Api.UPDATE_PRTT_RT_VAL
2129: (P_PRTT_RT_VAL_ID => L_Enroll_Info.PRTT_RT_VAL_ID
2130: ,P_PK_ID_TABLE_NAME => 'PER_PAY_PROPOSALS'
2131: ,P_PK_ID => l_Pay_Proposal_Id
2132: ,P_OBJECT_VERSION_NUMBER => L_Rt_Ovn
2133: ,P_EFFECTIVE_DATE => P_Effective_Date); */
2134:

Line 2168: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id

2164: End If;
2165: --
2166: -- Get current pay proposal
2167: --
2168: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id
2169: ,L_Enroll_Info.RT_Strt_Dt
2170: ,l_Payroll_name
2171: ,l_payroll_annualization_factor);
2172:

Line 3357: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;

3353:
3354:
3355:
3356:
3357: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3358: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3359: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3360: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3361: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;

Line 3358: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;

3354:
3355:
3356:
3357: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3358: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3359: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3360: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3361: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3362: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;

Line 3380: l_Change_Dt Per_Pay_proposals.Change_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;
3382: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3383: l_cur_sal number;
3384: l_per_in_ler_ovn number;

Line 3381: l_Del_proposal_Id Per_Pay_proposals.Pay_proposal_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;
3382: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3383: l_cur_sal number;
3384: l_per_in_ler_ovn number;
3385: l_procd_date date;

Line 3382: l_Del_Proposal_Ovn per_pay_Proposals.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;
3382: l_Del_Proposal_Ovn per_pay_Proposals.Object_version_Number%TYPE;
3383: l_cur_sal number;
3384: l_per_in_ler_ovn number;
3385: l_procd_date date;
3386: l_strtd_date date;

Line 3458: from Per_Pay_Proposals

3454: and pee.effective_end_date;
3455:
3456: Cursor Proposal_Dt (P_Assignment_Id IN Number) is
3457: Select Max(Change_Date)
3458: from Per_Pay_Proposals
3459: Where Assignment_Id = P_Assignment_id;
3460:
3461: Cursor Proposal_Dtls (P_Assignment_Id in Number) is
3462: Select Pay_Proposal_Id, Object_Version_Number

Line 3463: From Per_Pay_Proposals

3459: Where Assignment_Id = P_Assignment_id;
3460:
3461: Cursor Proposal_Dtls (P_Assignment_Id in Number) is
3462: Select Pay_Proposal_Id, Object_Version_Number
3463: From Per_Pay_Proposals
3464: Where Change_Date = l_Change_Dt
3465: and Assignment_id = P_Assignment_id;
3466:
3467: Cursor pay_basis_frequency (p_pay_basis_id in number)is

Line 3676: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id

3672: fnd_message.raise_error;
3673: End If;
3674:
3675:
3676: per_pay_proposals_populate.get_payroll(L_Enroll_Info.Assignment_Id
3677: ,L_Enroll_Info.RT_Strt_Dt
3678: ,l_Payroll_name
3679: ,l_payroll_annualization_factor);
3680: