APPS.GHR_SF52_API dependencies on GHR_REMARKS

Line 992: from ghr_remarks rem,

988: ,l_pa_request_id
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

Line 1030: from ghr_remarks rem,

1026: ,l_pa_request_id
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

Line 3156: from ghr_remarks rem

3152: ,p_pa_request_id
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

Line 3205: from ghr_remarks rem

3201: ,p_pa_request_id
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

Line 5011: l_remark_id ghr_remarks.remark_id%type;

5007: )
5008: is
5009:
5010: l_proc varchar2(72) := g_package || 'update_detail_remarks';
5011: l_remark_id ghr_remarks.remark_id%type;
5012: l_remark_description ghr_remarks.description%type;
5013: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
5014: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
5015: l_remk_desc ghr_pa_remarks.description%type;

Line 5012: l_remark_description ghr_remarks.description%type;

5008: is
5009:
5010: l_proc varchar2(72) := g_package || 'update_detail_remarks';
5011: l_remark_id ghr_remarks.remark_id%type;
5012: l_remark_description ghr_remarks.description%type;
5013: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
5014: l_rem_ovn ghr_pa_remarks.OBJECT_VERSION_NUMBER%type;
5015: l_remk_desc ghr_pa_remarks.description%type;
5016: