DBA Data[Home] [Help]

APPS.GHR_NFC_POSITION_EXTRACTS dependencies on BEN_EXT_RCD_IN_FILE

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 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 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