APPS.GHR_SF52_DO_UPDATE dependencies on GHR_GENERAL

Line 2589: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id

2585: select ast.user_status,ast.per_system_status
2586: from per_assignment_status_types ast,
2587: ghr_pa_history gph
2588: where gph.assignment_id = p_assignment_id
2589: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id
2590: and ast.user_status <> 'Detail NTE'
2591: and ast.per_system_status <> 'SUSP_ASSIGN' --Bug# 13087709
2592: and gph.table_name = 'PER_ASSIGNMENTS_F'
2593: and gph.effective_date < =

Line 3523: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id

3519: select ast.per_system_status ,ast.assignment_status_type_id
3520: from per_assignment_status_types ast,
3521: ghr_pa_history gph
3522: where gph.assignment_id = l_assignment_id
3523: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id
3524: and gph.table_name = 'PER_ASSIGNMENTS_F'
3525: and gph.effective_date < = l_old_effective_start_date
3526: order by gph.pa_history_id desc;
3527: --- Bug 13057211 end