DBA Data[Home] [Help]

APPS.CSTPPWRO dependencies on DUAL

Line 282: FROM DUAL

278: p_prog_app_id,
279: p_prog_id,
280: SYSDATE,
281: p_login_id
282: FROM DUAL
283: WHERE NOT EXISTS
284: ( SELECT 'X'
285: FROM wip_pac_period_balances wppb2
286: WHERE wppb2.pac_period_id = p_pac_period_id

Line 1664: FROM DUAL;

1660: p_prog_app_id,
1661: p_prog_id,
1662: SYSDATE,
1663: p_login_id
1664: FROM DUAL;
1665:
1666: --------------------------------------------------------------
1667: -- Get all Res Based Ovhds for this resource/dept/ct
1668: --------------------------------------------------------------

Line 1782: FROM DUAL;

1778: p_prog_app_id,
1779: p_prog_id,
1780: SYSDATE,
1781: p_login_id
1782: FROM DUAL;
1783:
1784: END IF; -- check c_rbo_rec.applied_value <>0
1785:
1786: END LOOP; -- c_rbo loop

Line 1893: FROM DUAL;

1889: p_prog_app_id,
1890: p_prog_id,
1891: SYSDATE,
1892: p_login_id
1893: FROM DUAL;
1894:
1895: END LOOP; -- MBO_REC loop
1896:
1897: END LOOP; -- ENT_REC loop