APPS.PQP_PENSION_EXTRACTS dependencies on PER_PAY_BASES

Line 3214: ,per_pay_bases ppb

3210: ,c_effective_date IN DATE
3211: ,c_business_group_id IN NUMBER) IS
3212: SELECT ppb.pay_annualization_factor
3213: FROM per_all_assignments_f paf
3214: ,per_pay_bases ppb
3215: WHERE assignment_id = c_assignment_id
3216: AND paf.pay_basis_id = ppb.pay_basis_id
3217: AND ppb.business_group_id = c_business_group_id
3218: AND paf.business_group_id = ppb.business_group_id

Line 3241: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

3237:
3238: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Data_Elements';
3239: l_return_value VARCHAR2(250);
3240: l_base_salary NUMBER(15,2);
3241: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
3242: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
3243: BEGIN
3244: hr_utility.set_location('Entering: '||l_proc_name, 5);
3245: IF g_primary_assig.EXISTS(p_assignment_id) THEN