APPS.PQP_HROSS_INTEGRATION dependencies on PAY_PAYROLLS_F

Line 337: FROM pay_payrolls_f ppf

333: CURSOR csr_payroll(c_payroll_id IN Number
334: ,c_business_group_id IN Number
335: ,c_effective_date IN Date) IS
336: SELECT payroll_name
337: FROM pay_payrolls_f ppf
338: WHERE ppf.payroll_id = c_payroll_id
339: AND ppf.business_group_id = c_business_group_id
340: AND c_effective_date BETWEEN ppf.effective_start_date
341: AND ppf.effective_end_date;

Line 2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

2738: l_cont_rec per_contact_relationships%ROWTYPE;
2739: l_pay_basis_name per_pay_bases.NAME%TYPE;
2740: l_organization_name hr_all_organization_units.NAME%TYPE;
2741: l_location_code hr_locations_all.location_code%TYPE;
2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
2743: l_job_name per_jobs.NAME%TYPE;
2744: l_position_name per_positions.NAME%TYPE;
2745: l_grade_name per_grades.NAME%TYPE;
2746: l_user_person_type per_person_types.user_person_type%TYPE;

Line 3934: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

3930: l_user_person_type per_person_types.user_person_type%TYPE;
3931: l_pay_basis_name per_pay_bases.NAME%TYPE;
3932: l_organization_name hr_all_organization_units.NAME%TYPE;
3933: l_location_code hr_locations_all.location_code%TYPE;
3934: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
3935: l_job_name per_jobs.NAME%TYPE;
3936: l_position_name per_positions.NAME%TYPE;
3937: l_grade_name per_grades.NAME%TYPE;
3938: