DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on PAY_PAYROLLS_F

Line 403: from pay_payrolls_f ppf

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

Line 7473: l_payroll_name pay_payrolls_f.payroll_name%type;

7469: l_user_person_type per_person_types.user_person_type%type;
7470: l_pay_basis_name per_pay_bases.name%type;
7471: l_organization_name hr_all_organization_units.name%type;
7472: l_location_code hr_locations_all.location_code%type;
7473: l_payroll_name pay_payrolls_f.payroll_name%type;
7474: l_job_name per_jobs.name%type;
7475: l_position_name per_positions.name%type;
7476: l_grade_name per_grades.name%type;
7477: