APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on DUAL

Line 1804: FROM DUAL;

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

Line 2040: FROM DUAL;

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

Line 2278: FROM DUAL;

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

Line 2499: FROM DUAL;

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

Line 2725: FROM DUAL;

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

Line 2919: FROM DUAL;

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