APPS.ZPB_AC_OPS dependencies on ZPB_SOLVE_OUTPUT_SELECTIONS

Line 760: INSERT INTO zpb_solve_output_selections

756: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
757: IS
758: BEGIN
759:
760: INSERT INTO zpb_solve_output_selections
761: (ANALYSIS_CYCLE_ID,
762: MEMBER,
763: MEMBER_ORDER,
764: DIMENSION,

Line 789: FROM zpb_solve_output_selections

785: SYSDATE,
786: fnd_global.USER_ID,
787: SYSDATE,
788: fnd_global.LOGIN_ID
789: FROM zpb_solve_output_selections
790: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
791:
792: END copy_solve_output_level_recs;
793:

Line 1192: DELETE FROM zpb_solve_output_selections

1188:
1189: DELETE FROM zpb_solve_allocation_defs
1190: WHERE analysis_cycle_id = ac_id_in;
1191:
1192: DELETE FROM zpb_solve_output_selections
1193: WHERE analysis_cycle_id = ac_id_in;
1194:
1195: DELETE FROM zpb_solve_input_selections
1196: WHERE analysis_cycle_id = ac_id_in;

Line 3330: -- output selection from table: zpb_solve_output_selections

3326: l_object_version_number NUMBER;
3327: l_hier_count NUMBER;
3328:
3329: -- This cursor will get all the distinct Dim-Hier pairs having more that one
3330: -- output selection from table: zpb_solve_output_selections
3331: CURSOR l_get_hierarchies_csr IS
3332: SELECT DISTINCT b.dimension,
3333: b.hierarchy
3334: FROM zpb_solve_output_selections b,

Line 3334: FROM zpb_solve_output_selections b,

3330: -- output selection from table: zpb_solve_output_selections
3331: CURSOR l_get_hierarchies_csr IS
3332: SELECT DISTINCT b.dimension,
3333: b.hierarchy
3334: FROM zpb_solve_output_selections b,
3335: zpb_lab_hierarchies_v lab
3336: WHERE b.analysis_cycle_id = p_analysis_cycle_id
3337: AND b.hierarchy = lab.object_aw_name
3338: AND b.dimension = lab.dimension

Line 3343: FROM zpb_solve_output_selections a

3339: AND EXISTS
3340: (SELECT a.dimension,
3341: a.member,
3342: COUNT(a.hierarchy)
3343: FROM zpb_solve_output_selections a
3344: WHERE a.analysis_cycle_id = p_analysis_cycle_id
3345: AND a.dimension = b.dimension
3346: GROUP BY a.dimension, a.member
3347: HAVING COUNT(a.hierarchy) > l_hier_count )

Line 3498: FROM zpb_solve_output_selections b,

3494: DELETE FROM zpb_solve_hier_order
3495: WHERE analysis_cycle_id = p_analysis_cycle_id
3496: AND hierarchy NOT IN
3497: (SELECT b.hierarchy
3498: FROM zpb_solve_output_selections b,
3499: zpb_lab_hierarchies_v lab
3500: WHERE b.analysis_cycle_id = p_analysis_cycle_id
3501: AND b.hierarchy = lab.object_aw_name
3502: AND b.dimension = lab.dimension

Line 3507: FROM zpb_solve_output_selections a

3503: AND EXISTS
3504: (SELECT a.dimension,
3505: a.member,
3506: COUNT(a.hierarchy)
3507: FROM zpb_solve_output_selections a
3508: WHERE a.analysis_cycle_id = p_analysis_cycle_id
3509: AND a.dimension = b.dimension
3510: GROUP BY a.dimension, a.member
3511: HAVING COUNT(a.hierarchy) > l_hier_count