DBA Data[Home] [Help]

APPS.BEN_EXT_CHLG dependencies on HR_LOCATIONS_ALL

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

3197: and nvl(pos.effective_end_date, sysdate)
3198: ;
3199:
3200:
3201: cursor c_location(p_location_id hr_locations_all.location_id%type)
3202: is
3203: select location_code
3204: from hr_locations_all hl
3205: where hl.location_id = p_location_id;

Line 3204: from hr_locations_all hl

3200:
3201: cursor c_location(p_location_id hr_locations_all.location_id%type)
3202: is
3203: select location_code
3204: from hr_locations_all hl
3205: where hl.location_id = p_location_id;
3206:
3207: cursor c_assignment_status
3208: (p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type)

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

3231: --
3232:
3233: l_old_position HR_ALL_POSITIONS_F.name%type;
3234: l_new_position HR_ALL_POSITIONS_F.name%type;
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

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

3232:
3233: l_old_position HR_ALL_POSITIONS_F.name%type;
3234: l_new_position HR_ALL_POSITIONS_F.name%type;
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