DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_PAY_BASES

Line 3941: ,per_pay_bases ppb

3937: ,c_effective_date IN DATE
3938: ,c_business_group_id IN NUMBER) IS
3939: SELECT ppb.pay_annualization_factor
3940: FROM per_all_assignments_f paf
3941: ,per_pay_bases ppb
3942: WHERE assignment_id = c_assignment_id
3943: AND paf.pay_basis_id = ppb.pay_basis_id
3944: AND ppb.business_group_id = c_business_group_id
3945: AND paf.business_group_id = ppb.business_group_id

Line 3970: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

3966: l_return_value VARCHAR2(250);
3967: l_base_salary NUMBER(15,2);
3968: i NUMBER;
3969: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
3970: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
3971:
3972: BEGIN
3973: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3974: i := p_business_group_id;