APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on DUAL

Line 1694: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */

1690: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1691: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1692: bl.resource_assignment_id = ra.resource_assignment_id
1693: union
1694: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */
1695:
1696: cursor revenue_ra_csr is
1697: select ra.project_id,
1698: ra.task_id,

Line 1749: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */

1745: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1746: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1747: bl.resource_assignment_id = ra.resource_assignment_id
1748: union
1749: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */
1750:
1751: cursor all_ra_csr is
1752: select ra.project_id,
1753: ra.task_id,

Line 1832: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */

1828: rlm.resource_list_id = pa_fp_view_plans_txn_pub.Get_Revenue_Resource_List_Id))) and
1829: exists (select 1 from pa_budget_lines bl where bl.budget_version_id = ra.budget_version_id and
1830: bl.resource_assignment_id = ra.resource_assignment_id
1831: union
1832: select 1 from dual where p_page_mode = c_edit_mode); /* exists condition included for bug 2710844 */
1833:
1834:
1835: -- PL/SQL tables
1836: