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 1126: from dual;

1122: ,l_ExpPoLineIdTab(m)
1123: ,l_ExpReference1Tab(m)
1124: ,l_ExpReference2Tab(m)
1125: ,l_ExpReference3Tab(m)
1126: from dual;
1127:
1128: commit;
1129: EXIT WHEN c_VIERBTC_txns%NOTFOUND;
1130: END LOOP;

Line 1606: from dual

1602: ,l_pktReference2Tab(j)
1603: ,l_pktReference3Tab(j)
1604: -- R12 Funds Management Uptake
1605: ,l_BurMethodcodeTab(j)
1606: from dual
1607: where l_DocTypTab(j) in ('CC_C_CO', 'CC_P_CO');
1608:
1609: for i in l_ProjTab.FIRST..l_ProjTab.LAST loop
1610: IF P_DEBUG_MODE = 'Y' THEN

Line 1859: from dual

1855: ,l_pktReference2Tab(l)
1856: ,l_pktReference3Tab(l)
1857: -- R12 Funds Management Uptake
1858: ,l_BurMethodcodeTab(l)
1859: from dual
1860: where l_DocTypTab(l) in ('AP','PO','REQ','CC_C_PAY','CC_P_PAY');
1861:
1862: for i in l_ProjTab.FIRST..l_ProjTab.LAST loop
1863: IF P_DEBUG_MODE = 'Y' THEN

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

2003:
2004: -- R12 Funds Management Uptake : Removed check of 'IF fc required'
2005:
2006: -- Get a new packet id
2007: select gl_bc_packets_s.nextval into l_packet_id from dual;
2008:
2009: IF P_DEBUG_MODE = 'Y' THEN
2010: pa_fck_util.debug_msg('MAINTAIN_BAL_FCHK: ' || 'PacketId = '|| l_packet_id);
2011: END IF;