APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on BEN_EXT_RCD_IN_FILE

Line 26: ,ben_ext_rcd_in_file rin

22: rin.hide_flag,
23: rcd.ext_rcd_id,
24: rcd.rcd_type_cd
25: FROM ben_ext_rcd rcd
26: ,ben_ext_rcd_in_file rin
27: ,ben_ext_dfn dfn
28: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
29: AND rin.ext_file_id = dfn.ext_file_id
30: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 129: ,ben_ext_rcd_in_file rin

125: -- =============================================================================
126: CURSOR c_get_rcd_id(c_seq IN Number) IS
127: SELECT rcd.ext_rcd_id
128: FROM ben_ext_rcd rcd
129: ,ben_ext_rcd_in_file rin
130: ,ben_ext_dfn dfn
131: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
132: AND rin.ext_file_id = dfn.ext_file_id
133: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 144: ,ben_ext_rcd_in_file rin

140: ,c_rcd_type_cd IN Varchar2
141: ) IS
142: SELECT rcd.ext_rcd_id
143: FROM ben_ext_rcd rcd
144: ,ben_ext_rcd_in_file rin
145: ,ben_ext_dfn dfn
146: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
147: AND rin.ext_file_id = dfn.ext_file_id
148: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 158: ,ben_ext_rcd_in_file rin

154: -- =============================================================================
155: CURSOR csr_ext_rcd_id_hidden(c_rcd_type_cd IN Varchar2) IS
156: SELECT rcd.ext_rcd_id
157: FROM ben_ext_rcd rcd
158: ,ben_ext_rcd_in_file rin
159: ,ben_ext_dfn dfn
160: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
161: AND rin.ext_file_id = dfn.ext_file_id
162: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 1988: ,ben_ext_rcd_in_file rin

1984: rin.hide_flag,
1985: rcd.ext_rcd_id,
1986: rcd.rcd_type_cd
1987: FROM ben_ext_rcd rcd
1988: ,ben_ext_rcd_in_file rin
1989: ,ben_ext_dfn dfn
1990: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
1991: AND rin.ext_file_id = dfn.ext_file_id
1992: AND rin.ext_rcd_id = rcd.ext_rcd_id