APPS.AMW_ORG_CERT_AGGR_PKG dependencies on AMW_ORG_CERT_AGGR_SUM

Line 85: MERGE INTO amw_org_cert_aggr_sum sum_tab

81: IF p_subsidiary_id = -1 THEN
82: RETURN;
83: END IF;
84:
85: MERGE INTO amw_org_cert_aggr_sum sum_tab
86: USING
87: (SELECT nvl(SUM(nvl(SUB_ORG_CERT,0)),0) SUB_ORG_CERT,
88: nvl(SUM(nvl(TOTAL_SUB_ORG,0)),0) TOTAL_SUB_ORG,
89: nvl(SUM(nvl(PROCESSES_CERTIFIED,0)),0) PROCESSES_CERTIFIED,

Line 126: amw_org_cert_aggr_sum ocas

122: PROC_CERT_ISSUES
123: FROM fnd_flex_values flv,
124: fnd_flex_value_children_v fchild,
125: fnd_flex_values flv_c,
126: amw_org_cert_aggr_sum ocas
127: WHERE flv.flex_value_id = p_subsidiary_id
128: AND fchild.flex_value_set_id = flv.flex_value_set_id
129: AND fchild.parent_flex_value = flv.flex_value
130: AND flv_c.flex_value_set_id = flv.flex_value_set_id

Line 238: (amw_org_cert_aggr_sum_s.nextval,

234: unmitigated_risks_prcnt,
235: ineff_controls_prcnt
236: )
237: VALUES
238: (amw_org_cert_aggr_sum_s.nextval,
239: p_certification_id,
240: 'SUBSIDIARY',
241: p_subsidiary_id,
242: sum_query.sub_org_cert,

Line 370: DELETE FROM amw_org_cert_aggr_sum

366:
367: SAVEPOINT populate_org_cert_aggr_rows;
368:
369: -- First clear out the existing data
370: DELETE FROM amw_org_cert_aggr_sum
371: WHERE certification_id = p_certification_id;
372:
373: -- Loop through the flex values and populate the aggregation info
374: FOR sub_info IN get_all_subs LOOP