APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on DUAL

Line 1899: FROM DUAL

1895:
1896: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1897: BEGIN
1898: SELECT 1 INTO l_count
1899: FROM DUAL
1900: WHERE EXISTS
1901: ( SELECT null
1902: FROM pa_tasks
1903: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID

Line 1917: FROM DUAL

1913:
1914: /* Check if any wp source budget line has a non-null rejection code */
1915: BEGIN
1916: SELECT 1 INTO l_bl_rejection_code_count
1917: FROM DUAL
1918: WHERE EXISTS
1919: ( SELECT null
1920: FROM pa_budget_lines
1921: WHERE budget_version_id = l_source_wp_ver_id

Line 1953: FROM DUAL

1949:
1950: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1951: BEGIN
1952: SELECT 1 INTO l_count
1953: FROM DUAL
1954: WHERE EXISTS
1955: ( SELECT null
1956: FROM pa_tasks
1957: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID

Line 1971: FROM DUAL

1967:
1968: /* Check if any fp source budget line has a non-null rejection code */
1969: BEGIN
1970: SELECT 1 INTO l_bl_rejection_code_count
1971: FROM DUAL
1972: WHERE EXISTS
1973: ( SELECT null
1974: FROM pa_budget_lines
1975: WHERE budget_version_id = l_source_fp_ver_id

Line 2052: FROM DUAL

2048: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
2049:
2050: BEGIN
2051: SELECT 1 INTO l_count
2052: FROM DUAL
2053: WHERE EXISTS
2054: ( SELECT null
2055: FROM PA_FORECAST_ITEMS
2056: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID