APPS.BEN_EXT_CHLG dependencies on PAY_ALL_PAYROLLS_F

Line 3215: (p_payroll_id pay_all_payrolls_f.payroll_id%type

3211: from per_assignment_status_types ast
3212: where ast.assignment_status_type_id = p_assignment_status_type_id;
3213:
3214: cursor c_payroll_name
3215: (p_payroll_id pay_all_payrolls_f.payroll_id%type
3216: ,p_effective_date date)
3217: is
3218: select ppf.payroll_name
3219: from pay_all_payrolls_f ppf

Line 3219: from pay_all_payrolls_f ppf

3215: (p_payroll_id pay_all_payrolls_f.payroll_id%type
3216: ,p_effective_date date)
3217: is
3218: select ppf.payroll_name
3219: from pay_all_payrolls_f ppf
3220: where payroll_id = p_payroll_id
3221: and p_effective_date between nvl(ppf.effective_start_date, sysdate)
3222: and nvl(ppf.effective_end_date, sysdate);
3223:

Line 3239: l_old_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683

3235: l_old_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683
3236: l_new_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683
3237: l_old_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3238: l_new_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3239: l_old_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3240: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3241: l_old_grade_name per_grades.name%type;
3242: l_new_grade_name per_grades.name%type;
3243: --

Line 3240: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683

3236: l_new_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683
3237: l_old_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3238: l_new_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3239: l_old_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3240: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3241: l_old_grade_name per_grades.name%type;
3242: l_new_grade_name per_grades.name%type;
3243: --
3244: l_proc varchar2(80) := 'ben_ext_chlg.log_asg_chg';