APPS.PA_BGT_BASELINE_PKG dependencies on DUAL

Line 475: from dual;

471: l_ParMemTab(i),
472: l_BurdCostTab(i),
473: 0,
474: 0
475: from dual;
476: commit;
477: IF P_DEBUG_MODE = 'Y' THEN
478: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'After inserting BGT lines');
479: END IF;

Line 1292: from dual;

1288: ,l_ExpPoLineIdTab(m)
1289: ,l_ExpReference1Tab(m)
1290: ,l_ExpReference2Tab(m)
1291: ,l_ExpReference3Tab(m)
1292: from dual;
1293:
1294: commit;
1295: EXIT WHEN c_VIERBTC_txns%NOTFOUND;
1296: END LOOP;

Line 1772: from dual

1768: ,l_pktReference2Tab(j)
1769: ,l_pktReference3Tab(j)
1770: -- R12 Funds Management Uptake
1771: ,l_BurMethodcodeTab(j)
1772: from dual
1773: where l_DocTypTab(j) in ('CC_C_CO', 'CC_P_CO');
1774:
1775: for i in l_ProjTab.FIRST..l_ProjTab.LAST loop
1776: IF P_DEBUG_MODE = 'Y' THEN

Line 2025: from dual

2021: ,l_pktReference2Tab(l)
2022: ,l_pktReference3Tab(l)
2023: -- R12 Funds Management Uptake
2024: ,l_BurMethodcodeTab(l)
2025: from dual
2026: where l_DocTypTab(l) in ('AP','PO','REQ','CC_C_PAY','CC_P_PAY');
2027:
2028: for i in l_ProjTab.FIRST..l_ProjTab.LAST loop
2029: IF P_DEBUG_MODE = 'Y' THEN

Line 2173: select gl_bc_packets_s.nextval into l_packet_id from dual;

2169:
2170: -- R12 Funds Management Uptake : Removed check of 'IF fc required'
2171:
2172: -- Get a new packet id
2173: select gl_bc_packets_s.nextval into l_packet_id from dual;
2174:
2175: IF P_DEBUG_MODE = 'Y' THEN
2176: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'PacketId = '|| l_packet_id);
2177: END IF;