1697:
1698:
1699: CURSOR cur_bdgtProjStrRejFlag IS
1700: SELECT 'Y'
1701: FROM DUAL
1702: WHERE EXISTS
1703: (SELECT null
1704: FROM pa_budget_lines bl
1705: WHERE bl.budget_version_id = l_budget_version_id
1711: );
1712:
1713: CURSOR cur_bdgtCstRejFlag IS
1714: SELECT 'Y'
1715: FROM DUAL
1716: WHERE EXISTS
1717: (SELECT null
1718: FROM pa_budget_lines bl
1719: ,pa_resource_assignments ra
1728: );
1729:
1730: CURSOR cur_bdgtBdnRejFlag IS
1731: SELECT 'Y'
1732: FROM DUAL
1733: WHERE EXISTS
1734: (SELECT null
1735: FROM pa_budget_lines bl
1736: ,pa_resource_assignments ra
1745: );
1746:
1747: CURSOR cur_bdgtRevnRejFlag IS
1748: SELECT 'Y'
1749: FROM DUAL
1750: WHERE EXISTS
1751: (SELECT null
1752: FROM pa_budget_lines bl
1753: ,pa_resource_assignments ra
1762: );
1763:
1764: CURSOR cur_bdgtPcConvRejFlag IS
1765: SELECT 'Y'
1766: FROM DUAL
1767: WHERE EXISTS
1768: (SELECT null
1769: FROM pa_budget_lines bl
1770: ,pa_resource_assignments ra
1779: );
1780:
1781: CURSOR cur_bdgtPfcConvRejFlag IS
1782: SELECT 'Y'
1783: FROM DUAL
1784: WHERE EXISTS
1785: (SELECT null
1786: FROM pa_budget_lines bl
1787: ,pa_resource_assignments ra