APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on DUAL

Line 1803: FROM DUAL;

1799: END IF;
1800: -- cancel the requisition encumbrance in the previous year
1801: SELECT gl_bc_packets_s.nextval
1802: INTO l_packet_id
1803: FROM DUAL;
1804:
1805: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
1806: INSERT INTO gl_bc_packets
1807: (

Line 2039: FROM DUAL;

2035:
2036: -- Now repeat the above to cancel the requisition encumbrances in the current year
2037: SELECT gl_bc_packets_s.nextval
2038: INTO l_packet_id
2039: FROM DUAL;
2040:
2041: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2042: INSERT INTO gl_bc_packets
2043: (

Line 2277: FROM DUAL;

2273: END IF;
2274: -- cancel the requisition encumbrance in the previous year
2275: SELECT gl_bc_packets_s.nextval
2276: INTO l_packet_id
2277: FROM DUAL;
2278:
2279: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2280: INSERT INTO gl_bc_packets
2281: (

Line 2498: FROM DUAL;

2494:
2495: -- Now repeat the above to cancel the requisition encumbrances in the current year
2496: SELECT gl_bc_packets_s.nextval
2497: INTO l_packet_id
2498: FROM DUAL;
2499:
2500: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2501: INSERT INTO gl_bc_packets
2502: (

Line 2724: FROM DUAL;

2720: END IF;
2721: -- cancel the PO encumbrance in the previous year
2722: SELECT gl_bc_packets_s.nextval
2723: INTO l_packet_id
2724: FROM DUAL;
2725:
2726: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2727: INSERT INTO gl_bc_packets
2728: (

Line 2918: FROM DUAL;

2914:
2915: -- Now repeat the above to cancel the requisition encumbrances in the current year
2916: SELECT gl_bc_packets_s.nextval
2917: INTO l_packet_id
2918: FROM DUAL;
2919:
2920: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2921: INSERT INTO gl_bc_packets
2922: (