APPS.PQH_GSP_UTILITY dependencies on PER_PAY_BASES

Line 1759: l_pay_basis_frequency Per_pay_bases.pay_basis%TYPE;

1755: L_FREQUENCY per_time_period_types.period_type%TYPE;
1756: L_ANNUAL_SALARY Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1757: L_PAY_BASIS Varchar2(5);
1758: L_REASON_CD Per_pay_Proposals.proposal_reason%TYPE;
1759: l_pay_basis_frequency Per_pay_bases.pay_basis%TYPE;
1760: L_CURRENCY Ben_Pgm_F.Pgm_Uom%TYPE;
1761: L_STATUS Number(10);
1762:
1763: Cursor Sal is

Line 1781: From Per_Pay_Bases ppb,

1777: Between Pev.Effective_Start_Date and Pev.Effective_End_Date;
1778:
1779: Cursor Pay_Bases_Element is
1780: Select input_value_id
1781: From Per_Pay_Bases ppb,
1782: Per_All_Assignments_f paf
1783: Where paf.Assignment_Id = p_Assignment_Id
1784: and p_Effective_Date
1785: Between Paf.Effective_Start_Date and Paf.Effective_End_Date

Line 4122: Per_Pay_Bases ppb

4118:
4119: CURSOR C_Pay_Basis IS
4120: select Ppb.Pay_Annualization_Factor,Ppb.Pay_basis
4121: From Per_All_Assignments_f asg,
4122: Per_Pay_Bases ppb
4123: where Asg.Assignment_id = P_Assignment_Id
4124: and P_effective_date
4125: between Asg.Effective_Start_Date
4126: and Asg.Effective_End_Date

Line 4131: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

4127: and Ppb.Pay_Basis_Id = Asg.Pay_Basis_Id;
4128:
4129: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4130: l_precision Fnd_Currencies.Precision%TYPE;
4131: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4132: l_ret_amount Number;
4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4134: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4135: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;

Line 4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

4129: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4130: l_precision Fnd_Currencies.Precision%TYPE;
4131: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4132: l_ret_amount Number;
4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4134: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4135: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4136: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4137: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

Line 4136: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;

4132: l_ret_amount Number;
4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4134: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4135: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4136: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4137: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
4138:
4139: Begin
4140:

Line 4385: From per_pay_bases

4381: -- Local variables
4382: --
4383: Cursor csr_sal_basis_iv is
4384: Select 'x'
4385: From per_pay_bases
4386: where business_group_id = p_business_group_id
4387: and rate_id is null
4388: and input_value_id = p_input_value_id
4389: and pay_basis_id <> p_basis_id;