APPS.PQP_PENSION_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 3669: FROM pay_payrolls_f pay

3665: CURSOR csr_pay_name(c_payroll_id IN NUMBER
3666: ,c_end_date IN DATE
3667: )IS
3668: SELECT pay.payroll_name
3669: FROM pay_payrolls_f pay
3670: WHERE pay.payroll_id = c_payroll_id
3671: AND c_end_date BETWEEN pay.effective_start_date
3672: AND pay.effective_end_date;
3673:

Line 3703: l_payroll_name pay_payrolls_f.payroll_name%TYPE ;

3699: l_extract_name ben_ext_dfn.NAME%TYPE;
3700: l_element_set pay_element_sets.element_set_name%TYPE;
3701: l_element_name pay_element_types_f.element_name%TYPE;
3702: l_gre_name hr_organization_units.NAME%TYPE ;
3703: l_payroll_name pay_payrolls_f.payroll_name%TYPE ;
3704: l_con_set_name pay_consolidation_sets.consolidation_set_name%TYPE;
3705: l_org_name hr_all_organization_units.NAME%TYPE;
3706: l_person_type per_person_types.user_person_type%TYPE;
3707: l_location hr_locations_all.location_code%TYPE;