APPS.GHR_NFC_POSITION_EXTRACTS dependencies on BEN_EXT_RCD

Line 101: FROM ben_ext_rcd rcd

97: -- =============================================================================
98: CURSOR csr_ext_rcd_id(c_hide_flag IN VARCHAR2
99: ,c_rcd_type_cd IN VARCHAR2) IS
100: SELECT rcd.ext_rcd_id
101: FROM ben_ext_rcd rcd
102: ,ben_ext_rcd_in_file rin
103: ,ben_ext_dfn dfn
104: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
105: AND rin.ext_file_id = dfn.ext_file_id

Line 102: ,ben_ext_rcd_in_file rin

98: CURSOR csr_ext_rcd_id(c_hide_flag IN VARCHAR2
99: ,c_rcd_type_cd IN VARCHAR2) IS
100: SELECT rcd.ext_rcd_id
101: FROM ben_ext_rcd rcd
102: ,ben_ext_rcd_in_file rin
103: ,ben_ext_dfn dfn
104: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
105: AND rin.ext_file_id = dfn.ext_file_id
106: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 158: FROM ben_ext_rcd rcd

154: ,c_position_id IN VARCHAR2
155: ,c_business_group_id IN NUMBER) IS
156:
157: SELECT rslt.ext_rslt_dtl_id
158: FROM ben_ext_rcd rcd
159: ,ben_ext_rcd_in_file rin
160: ,ben_ext_dfn dfn
161: ,ben_ext_rslt_dtl rslt
162: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id

Line 159: ,ben_ext_rcd_in_file rin

155: ,c_business_group_id IN NUMBER) IS
156:
157: SELECT rslt.ext_rslt_dtl_id
158: FROM ben_ext_rcd rcd
159: ,ben_ext_rcd_in_file rin
160: ,ben_ext_dfn dfn
161: ,ben_ext_rslt_dtl rslt
162: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
163: AND rin.ext_file_id = dfn.ext_file_id

Line 3469: FROM ben_ext_rcd rcd

3465:
3466: CURSOR csr_rslt_dtl_sort(c_ext_rslt_id IN Number
3467: ,c_ext_dfn_id IN Number ) IS
3468: SELECT dtl.*
3469: FROM ben_ext_rcd rcd
3470: ,ben_ext_rcd_in_file rin
3471: ,ben_ext_dfn dfn
3472: ,ben_ext_rslt_dtl dtl
3473: WHERE dfn.ext_dfn_id = c_ext_dfn_id

Line 3470: ,ben_ext_rcd_in_file rin

3466: CURSOR csr_rslt_dtl_sort(c_ext_rslt_id IN Number
3467: ,c_ext_dfn_id IN Number ) IS
3468: SELECT dtl.*
3469: FROM ben_ext_rcd rcd
3470: ,ben_ext_rcd_in_file rin
3471: ,ben_ext_dfn dfn
3472: ,ben_ext_rslt_dtl dtl
3473: WHERE dfn.ext_dfn_id = c_ext_dfn_id
3474: AND rin.ext_file_id = dfn.ext_file_id

Line 3483: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

3479: and dtl.ext_rslt_id = c_ext_rslt_id
3480: ORDER BY dtl.val_02 desc;
3481:
3482:
3483: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3484: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3485: l_proc_name VARCHAR2(150):= g_proc_name||'Del_Post_Process_Recs';
3486: l_return_value NUMBER := 0; --0= Sucess, -1=Error
3487: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;

Line 3484: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

3480: ORDER BY dtl.val_02 desc;
3481:
3482:
3483: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3484: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
3485: l_proc_name VARCHAR2(150):= g_proc_name||'Del_Post_Process_Recs';
3486: l_return_value NUMBER := 0; --0= Sucess, -1=Error
3487: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
3488: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;