1976:
1977: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
1978: BEGIN
1979: SELECT 1 INTO l_count
1980: FROM DUAL
1981: WHERE EXISTS
1982: ( SELECT null
1983: FROM pa_tasks
1984: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
1994:
1995: /* Check if any wp source budget line has a non-null rejection code */
1996: BEGIN
1997: SELECT 1 INTO l_bl_rejection_code_count
1998: FROM DUAL
1999: WHERE EXISTS
2000: ( SELECT null
2001: FROM pa_budget_lines
2002: WHERE budget_version_id = l_source_wp_ver_id
2030:
2031: IF l_gen_src_code = 'TASK_LEVEL_SEL' THEN
2032: BEGIN
2033: SELECT 1 INTO l_count
2034: FROM DUAL
2035: WHERE EXISTS
2036: ( SELECT null
2037: FROM pa_tasks
2038: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID
2048:
2049: /* Check if any fp source budget line has a non-null rejection code */
2050: BEGIN
2051: SELECT 1 INTO l_bl_rejection_code_count
2052: FROM DUAL
2053: WHERE EXISTS
2054: ( SELECT null
2055: FROM pa_budget_lines
2056: WHERE budget_version_id = l_source_fp_ver_id
2129: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
2130:
2131: BEGIN
2132: SELECT 1 INTO l_count
2133: FROM DUAL
2134: WHERE EXISTS
2135: ( SELECT null
2136: FROM PA_FORECAST_ITEMS
2137: WHERE project_id = l_fp_cols_rec_tgt.X_PROJECT_ID