DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on PAY_PAYROLLS_F

Line 404: from pay_payrolls_f ppf

400: cursor csr_payroll(c_payroll_id in number
401: ,c_business_group_id in number
402: ,c_effective_date in date) is
403: select payroll_name
404: from pay_payrolls_f ppf
405: where ppf.payroll_id = c_payroll_id
406: and ppf.business_group_id = c_business_group_id
407: and c_effective_date between ppf.effective_start_date
408: and ppf.effective_end_date;

Line 7877: l_payroll_name pay_payrolls_f.payroll_name%type;

7873: l_user_person_type per_person_types.user_person_type%type;
7874: l_pay_basis_name per_pay_bases.name%type;
7875: l_organization_name hr_all_organization_units.name%type;
7876: l_location_code hr_locations_all.location_code%type;
7877: l_payroll_name pay_payrolls_f.payroll_name%type;
7878: l_job_name per_jobs.name%type;
7879: l_position_name per_positions.name%type;
7880: l_grade_name per_grades.name%type;
7881: