APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_REPORT_DETAILS

Line 33: FROM ben_tcs_report_details

29:
30: CURSOR suc_ppl ( v_benefit_action_id IN NUMBER) IS
31: SELECT
32: COUNT(UNIQUE(person_id)) cnt_ppl
33: FROM ben_tcs_report_details
34: WHERE benefit_action_id = v_benefit_action_id
35: AND stmt_created ='Y' ;
36:
37: CURSOR err_ppl ( v_benefit_action_id IN NUMBER) IS

Line 40: FROM ben_tcs_report_details

36:
37: CURSOR err_ppl ( v_benefit_action_id IN NUMBER) IS
38: SELECT
39: COUNT(UNIQUE(person_id)) cnt_ppl
40: FROM ben_tcs_report_details
41: WHERE benefit_action_id = v_benefit_action_id
42: AND stmt_created ='E' ;
43:
44: --

Line 220: INSERT INTO BEN_TCS_REPORT_DETAILS(

216:
217: FOR i IN 1 .. l_rep_rec.COUNT
218: LOOP
219: IF (l_rep_rec(i).P_TYPE = -1) THEN
220: INSERT INTO BEN_TCS_REPORT_DETAILS(
221: BENEFIT_ACTION_ID,
222: BUSINESS_GROUP_ID,
223: BUSINESS_GROUP_NAME,
224: ELIGY_ID,

Line 242: BEN_TCS_REPORT_DETAILS_S.NEXTVAL

238: l_rep_rec(i).STMT_ID,
239: l_rep_rec(i).STMT_NAME,
240: l_rep_rec(i).SETUP_VALID,
241: l_rep_rec(i).TOTAL_PERSONS,
242: BEN_TCS_REPORT_DETAILS_S.NEXTVAL
243: );
244: ELSE
245: INSERT INTO BEN_TCS_REPORT_DETAILS(
246: BENEFIT_ACTION_ID,

Line 245: INSERT INTO BEN_TCS_REPORT_DETAILS(

241: l_rep_rec(i).TOTAL_PERSONS,
242: BEN_TCS_REPORT_DETAILS_S.NEXTVAL
243: );
244: ELSE
245: INSERT INTO BEN_TCS_REPORT_DETAILS(
246: BENEFIT_ACTION_ID,
247: BUSINESS_GROUP_ID ,
248: BUSINESS_GROUP_NAME,
249: ASSIGNMENT_NUMBER,

Line 275: BEN_TCS_REPORT_DETAILS_S.NEXTVAL,

271: l_rep_rec(i).STMT_NAME,
272: l_rep_rec(i).FULL_NAME,
273: l_rep_rec(i).EMPLOYEE_NUMBER,
274: l_rep_rec(i).JOB_NAME,
275: BEN_TCS_REPORT_DETAILS_S.NEXTVAL,
276: l_rep_rec(i).ERROR
277: );
278: END IF;
279: END LOOP;