APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PA_HISTORY

Line 1480: from ghr_pa_history

1476: --bug# 12596901,12994100
1477: /*l_scd_tsp per_people_extra_info.pei_information6%type;
1478: cursor c_scd_tsp(c_person_id ghr_pa_requests.person_id%type,eff_date ghr_pa_requests.effective_date%type) is
1479: select information12
1480: from ghr_pa_history
1481: where person_id = c_person_id
1482: and information5 = 'GHR_US_PER_SCD_INFORMATION'
1483: and table_name = 'PER_PEOPLE_EXTRA_INFO'
1484: and effective_date = eff_date

Line 2587: ghr_pa_history gph

2583: -- 13014948,13023669 modified the cursor to handle the same day Detail and other actions
2584: Cursor c_old_user_status is
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

Line 3355: FROM ghr_pa_history pah

3351: cursor c_upd_primary_address(p_pa_request_id IN NUMBER,
3352: p_address_id IN NUMBER)
3353: is
3354: SELECT pah.information1
3355: FROM ghr_pa_history pah
3356: WHERE pah.table_name = 'PER_ADDRESSES'
3357: AND pah.information1 = p_address_id
3358: AND pah.pa_request_id IN
3359: (

Line 3521: ghr_pa_history gph

3517: --- Bug 13057211 start
3518: Cursor c_user_old_status is
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