APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 204: FROM ben_ext_data_elmt_in_rcd

200: ,p_business_group_id in number
201: ) RETURN NUMBER IS
202: CURSOR c_new_data_elmt_in_rcd_id IS
203: SELECT ext_data_elmt_in_rcd_id
204: FROM ben_ext_data_elmt_in_rcd
205: WHERE ext_rcd_id = p_new_ext_rcd_id
206: AND ext_data_elmt_id = (SELECT ext_data_elmt_id
207: FROM ben_ext_data_elmt
208: WHERE (p_business_group_id is null or

Line 214: ,ben_ext_data_elmt_in_rcd DinR

210: and name =
211: (SELECT fix_name_length(p_new_extract_name||' '||De.name
212: ,c_ExtName_Maxlen)
213: FROM ben_ext_data_elmt De
214: ,ben_ext_data_elmt_in_rcd DinR
215: WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
216: AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
217: )
218: );

Line 248: FROM ben_ext_data_elmt_in_rcd

244: ) RETURN NUMBER IS
245:
246: CURSOR c_new_data_elmt_in_rcd_id IS
247: SELECT ext_data_elmt_in_rcd_id
248: FROM ben_ext_data_elmt_in_rcd
249: WHERE ext_rcd_id = (SELECT ext_rcd_id
250: FROM ben_ext_rcd_in_file
251: WHERE ext_rcd_in_file_id = p_new_rcd_in_file_id
252: )

Line 259: ,ben_ext_data_elmt_in_rcd DinR

255: WHERE name =
256: (SELECT fix_name_length(p_new_extract_name||' '||De.name
257: ,c_ExtName_Maxlen)
258: FROM ben_ext_data_elmt De
259: ,ben_ext_data_elmt_in_rcd DinR
260: WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
261: AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
262: )
263: );

Line 735: FROM ben_ext_data_elmt_in_rcd DinR, ben_ext_data_elmt DElmt

731: );
732:
733: CURSOR c_ext_data_elmt_in_rcd(p_ext_rcd_id IN NUMBER) IS
734: SELECT DinR.*
735: FROM ben_ext_data_elmt_in_rcd DinR, ben_ext_data_elmt DElmt
736: WHERE DinR.ext_rcd_id = p_ext_rcd_id
737: AND Dinr.ext_data_elmt_id = DElmt.ext_data_elmt_id
738: AND ((DinR.business_group_id IS NULL AND DinR.legislation_code IS NULL)
739: OR (DinR.legislation_code IS NOT NULL

Line 1115: -- Insert new record in BEN_EXT_DATA_ELMT_IN_RCD using Row Handler

1111: );
1112: END IF;
1113: END; -- Insert into BEN_EXT_DATA_ELMT using Row Handler
1114:
1115: -- Insert new record in BEN_EXT_DATA_ELMT_IN_RCD using Row Handler
1116: ben_xer_ins.ins
1117: (
1118: p_ext_data_elmt_in_rcd_id => l_new_ext_data_elmt_in_rcd_id -- OUT
1119: ,p_seq_num => r_curr_data_elmt_in_rcd.seq_num