APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_DATA_ELMT_DECD

Line 759: FROM ben_ext_data_elmt_decd

755: );
756:
757: CURSOR c_ext_data_elmt_decd(p_ext_data_elmt_id IN NUMBER) IS
758: SELECT *
759: FROM ben_ext_data_elmt_decd
760: WHERE ext_data_elmt_id = p_ext_data_elmt_id
761: AND ((business_group_id IS NULL AND legislation_code IS NULL)
762: OR (legislation_code IS NOT NULL
763: AND legislation_code = p_legislation_code)

Line 1136: -- IF Data Element Type = DECODE then copy data in BEN_EXT_DATA_ELMT_DECD

1132: );
1133:
1134: IF NOT l_data_elmt_present THEN
1135:
1136: -- IF Data Element Type = DECODE then copy data in BEN_EXT_DATA_ELMT_DECD
1137: IF r_curr_data_elmt.data_elmt_typ_cd = 'D' THEN
1138:
1139: FOR r_curr_ext_data_elmt_decd IN c_ext_data_elmt_decd(r_curr_data_elmt.ext_data_elmt_id)
1140: LOOP -- 11 Get Data Element Decode data for current EXT_DATA_ELMT_ID

Line 1142: -- Insert new record in BEN_EXT_DATA_ELMT_DECD using Row Handler

1138:
1139: FOR r_curr_ext_data_elmt_decd IN c_ext_data_elmt_decd(r_curr_data_elmt.ext_data_elmt_id)
1140: LOOP -- 11 Get Data Element Decode data for current EXT_DATA_ELMT_ID
1141:
1142: -- Insert new record in BEN_EXT_DATA_ELMT_DECD using Row Handler
1143: ben_xdd_ins.ins
1144: (
1145: p_ext_data_elmt_decd_id => l_new_ext_data_elmt_decd_id -- OUT
1146: ,p_val => r_curr_ext_data_elmt_decd.val