APPS.GHR_SF52_API dependencies on GHR_NOAC_REMARKS

Line 969: ghr_noac_remarks nre

965: ,rem.remark_id
966: ,rem.description
967: ,1
968: from ghr_remarks rem,
969: ghr_noac_remarks nre
970: where nre.nature_of_action_id = p_first_noa_id
971: and nre.required_flag = 'Y'
972: and l_effective_date
973: between nre.date_from

Line 996: ghr_noac_remarks nre

992: ,rem.remark_id
993: ,rem.description
994: ,1
995: from ghr_remarks rem,
996: ghr_noac_remarks nre
997: where nre.nature_of_action_id = p_second_noa_id
998: and nre.required_flag = 'Y'
999: and l_effective_date
1000: between nre.date_from

Line 2995: from ghr_noac_remarks

2991: delete from ghr_pa_remarks pre
2992: where pre.pa_request_id = p_pa_request_id
2993: and pre.remark_id in
2994: (select remark_id
2995: from ghr_noac_remarks
2996: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
2997: if p_first_noa_id is not null then
2998: hr_utility.set_location(l_proc, 10);
2999:

Line 3013: ,ghr_noac_remarks nre

3009: ,rem.remark_id
3010: ,rem.description
3011: ,1
3012: from ghr_remarks rem
3013: ,ghr_noac_remarks nre
3014: where nre.nature_of_action_id = p_first_noa_id
3015: and nre.required_flag = 'Y'
3016: and l_effective_date
3017: between nre.date_from

Line 3035: from ghr_noac_remarks

3031: delete from ghr_pa_remarks pre
3032: where pre.pa_request_id = p_pa_request_id
3033: and pre.remark_id in
3034: (select remark_id
3035: from ghr_noac_remarks
3036: where nature_of_action_id = ghr_par_shd.g_old_rec.second_noa_id);
3037: if p_second_noa_id is not null then
3038: insert into ghr_pa_remarks
3039: (pa_remark_id

Line 3051: ,ghr_noac_remarks nre

3047: ,rem.remark_id
3048: ,rem.description
3049: ,1
3050: from ghr_remarks rem
3051: ,ghr_noac_remarks nre
3052: where nre.nature_of_action_id = p_second_noa_id
3053: and nre.required_flag = 'Y'
3054: and l_effective_date
3055: between nre.date_from