APPS.GHR_SF52_API dependencies on GHR_NOAC_REMARKS

Line 993: ghr_noac_remarks nre

989: ,rem.remark_id
990: ,rem.description
991: ,1
992: from ghr_remarks rem,
993: ghr_noac_remarks nre
994: where nre.nature_of_action_id = p_first_noa_id
995: and nre.required_flag = 'Y'
996: and l_effective_date
997: between nre.date_from

Line 1031: ghr_noac_remarks nre

1027: ,rem.remark_id
1028: ,rem.description
1029: ,1
1030: from ghr_remarks rem,
1031: ghr_noac_remarks nre
1032: where nre.nature_of_action_id = p_second_noa_id
1033: and nre.required_flag = 'Y'
1034: and l_effective_date
1035: between nre.date_from

Line 3139: from ghr_noac_remarks

3135: delete from ghr_pa_remarks pre
3136: where pre.pa_request_id = p_pa_request_id
3137: and pre.remark_id in
3138: (select remark_id
3139: from ghr_noac_remarks
3140: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
3141: if p_first_noa_id is not null then
3142: hr_utility.set_location(l_proc, 10);
3143:

Line 3157: ,ghr_noac_remarks nre

3153: ,rem.remark_id
3154: ,rem.description
3155: ,1
3156: from ghr_remarks rem
3157: ,ghr_noac_remarks nre
3158: where nre.nature_of_action_id = p_first_noa_id
3159: and nre.required_flag = 'Y'
3160: and l_effective_date
3161: between nre.date_from

Line 3179: from ghr_noac_remarks

3175: delete from ghr_pa_remarks pre
3176: where pre.pa_request_id = p_pa_request_id
3177: and pre.remark_id in
3178: (select remark_id
3179: from ghr_noac_remarks
3180: where nature_of_action_id = ghr_par_shd.g_old_rec.second_noa_id);
3181: --Begin Bug# 7174094
3182: l_separation_flag := FALSE;
3183: IF p_first_noa_code in ('002') THEN

Line 3206: ,ghr_noac_remarks nre

3202: ,rem.remark_id
3203: ,rem.description
3204: ,1
3205: from ghr_remarks rem
3206: ,ghr_noac_remarks nre
3207: where nre.nature_of_action_id = p_second_noa_id
3208: and nre.required_flag = 'Y'
3209: and l_effective_date
3210: between nre.date_from