APPS.PQH_GSP_UTILITY dependencies on PER_PAY_BASES

Line 1640: l_pay_basis_frequency Per_pay_bases.pay_basis%TYPE;

1636: L_FREQUENCY per_time_period_types.period_type%TYPE;
1637: L_ANNUAL_SALARY Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1638: L_PAY_BASIS Varchar2(5);
1639: L_REASON_CD Per_pay_Proposals.proposal_reason%TYPE;
1640: l_pay_basis_frequency Per_pay_bases.pay_basis%TYPE;
1641: L_CURRENCY Ben_Pgm_F.Pgm_Uom%TYPE;
1642: L_STATUS Number(10);
1643:
1644: Cursor Sal is

Line 1662: From Per_Pay_Bases ppb,

1658: Between Pev.Effective_Start_Date and Pev.Effective_End_Date;
1659:
1660: Cursor Pay_Bases_Element is
1661: Select input_value_id
1662: From Per_Pay_Bases ppb,
1663: Per_All_Assignments_f paf
1664: Where paf.Assignment_Id = p_Assignment_Id
1665: and p_Effective_Date
1666: Between Paf.Effective_Start_Date and Paf.Effective_End_Date

Line 4003: Per_Pay_Bases ppb

3999:
4000: CURSOR C_Pay_Basis IS
4001: select Ppb.Pay_Annualization_Factor,Ppb.Pay_basis
4002: From Per_All_Assignments_f asg,
4003: Per_Pay_Bases ppb
4004: where Asg.Assignment_id = P_Assignment_Id
4005: and P_effective_date
4006: between Asg.Effective_Start_Date
4007: and Asg.Effective_End_Date

Line 4012: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

4008: and Ppb.Pay_Basis_Id = Asg.Pay_Basis_Id;
4009:
4010: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4011: l_precision Fnd_Currencies.Precision%TYPE;
4012: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4013: l_ret_amount Number;
4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4015: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4016: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;

Line 4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

4010: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4011: l_precision Fnd_Currencies.Precision%TYPE;
4012: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4013: l_ret_amount Number;
4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4015: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4016: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4017: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4018: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

Line 4017: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;

4013: l_ret_amount Number;
4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4015: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4016: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4017: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4018: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
4019:
4020: Begin
4021:

Line 4266: From per_pay_bases

4262: -- Local variables
4263: --
4264: Cursor csr_sal_basis_iv is
4265: Select 'x'
4266: From per_pay_bases
4267: where business_group_id = p_business_group_id
4268: and rate_id is null
4269: and input_value_id = p_input_value_id
4270: and pay_basis_id <> p_basis_id;