APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on GMS_BUDGET_LINES

Line 12: gms_budget_lines pbl

8: CURSOR budget_lines_csr IS
9: SELECT 1
10: FROM gms_budget_versions pbv,
11: gms_resource_assignments pra,
12: gms_budget_lines pbl
13: WHERE pbv.budget_version_id = pra.budget_version_id
14: AND pbv.award_id = P_AWARD_ID
15: AND pra.resource_assignment_id = pbl.resource_assignment_id
16: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y'))

Line 227: gms_budget_lines pbl

223: CURSOR budget_lines_csr IS
224: SELECT 1
225: FROM gms_budget_versions pbv,
226: gms_resource_assignments pra,
227: gms_budget_lines pbl
228: WHERE pbv.budget_version_id = pra.budget_version_id
229: AND pbv.award_id = P_AWARD_ID
230: AND pra.resource_assignment_id = pbl.resource_assignment_id
231: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y'))

Line 468: gms_budget_lines gbl

464: gra.task_id,
465: gbl.start_date,
466: gbl.end_date
467: from gms_resource_assignments gra,
468: gms_budget_lines gbl
469: where gra.resource_assignment_id = gbl.resource_assignment_id
470: and gra.budget_version_id = p_budget_version_id;
471:
472: l_return_status NUMBER ;

Line 531: gms_budget_lines pbl

527: CURSOR budget_lines_csr IS
528: SELECT 1
529: FROM gms_budget_versions pbv,
530: gms_resource_assignments pra,
531: gms_budget_lines pbl
532: WHERE pbv.budget_version_id = pra.budget_version_id
533: AND pbv.project_id = P_PROJECT_ID
534: AND pra.resource_assignment_id = pbl.resource_assignment_id
535: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y'))

Line 641: gms_budget_lines pbl

637: WHERE EXISTS
638: ( SELECT 1
639: FROM gms_budget_versions pbv,
640: gms_resource_assignments pra,
641: gms_budget_lines pbl
642: WHERE pbv.budget_version_id = pra.budget_version_id
643: AND pbv.project_id = P_PROJECT_ID
644: AND pra.resource_assignment_id = pbl.resource_assignment_id
645: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y')));

Line 790: gms_budget_lines pbl

786: CURSOR budget_lines_csr IS
787: SELECT 1
788: FROM gms_budget_versions pbv,
789: gms_resource_assignments pra,
790: gms_budget_lines pbl
791: WHERE pbv.budget_version_id = pra.budget_version_id
792: AND pbv.project_id = P_PROJECT_ID
793: AND pra.resource_assignment_id = pbl.resource_assignment_id
794: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y'))