DBA Data[Home] [Help]

APPS.BEN_EXT_CHLG dependencies on HR_LOCATIONS_ALL

Line 3107: cursor c_location(p_location_id hr_locations_all.location_id%type)

3103: and nvl(pos.effective_end_date, sysdate)
3104: ;
3105:
3106:
3107: cursor c_location(p_location_id hr_locations_all.location_id%type)
3108: is
3109: select location_code
3110: from hr_locations_all hl
3111: where hl.location_id = p_location_id;

Line 3110: from hr_locations_all hl

3106:
3107: cursor c_location(p_location_id hr_locations_all.location_id%type)
3108: is
3109: select location_code
3110: from hr_locations_all hl
3111: where hl.location_id = p_location_id;
3112:
3113: cursor c_assignment_status
3114: (p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type)

Line 3141: l_old_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683

3137: --
3138:
3139: l_old_position HR_ALL_POSITIONS_F.name%type;
3140: l_new_position HR_ALL_POSITIONS_F.name%type;
3141: l_old_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683
3142: l_new_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683
3143: l_old_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3144: l_new_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3145: l_old_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683

Line 3142: l_new_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683

3138:
3139: l_old_position HR_ALL_POSITIONS_F.name%type;
3140: l_new_position HR_ALL_POSITIONS_F.name%type;
3141: l_old_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683
3142: l_new_location hr_locations_all.location_code%type; -- UTF Change Bug 2254683
3143: l_old_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3144: l_new_assignment_status per_assignment_status_types.user_status%type; -- UTF Change Bug 2254683
3145: l_old_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3146: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683