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 236: gms_budget_lines pbl

232: CURSOR budget_lines_csr IS
233: SELECT 1
234: FROM gms_budget_versions pbv,
235: gms_resource_assignments pra,
236: gms_budget_lines pbl
237: WHERE pbv.budget_version_id = pra.budget_version_id
238: AND pbv.award_id = P_AWARD_ID
239: AND pra.resource_assignment_id = pbl.resource_assignment_id
240: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y'))

Line 486: gms_budget_lines gbl

482: gra.task_id,
483: gbl.start_date,
484: gbl.end_date
485: from gms_resource_assignments gra,
486: gms_budget_lines gbl
487: where gra.resource_assignment_id = gbl.resource_assignment_id
488: and gra.budget_version_id = p_budget_version_id;
489:
490: l_return_status NUMBER ;

Line 549: gms_budget_lines pbl

545: CURSOR budget_lines_csr IS
546: SELECT 1
547: FROM gms_budget_versions pbv,
548: gms_resource_assignments pra,
549: gms_budget_lines pbl
550: WHERE pbv.budget_version_id = pra.budget_version_id
551: AND pbv.project_id = P_PROJECT_ID
552: AND pra.resource_assignment_id = pbl.resource_assignment_id
553: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y'))

Line 687: gms_budget_lines pbl

683: WHERE EXISTS
684: ( SELECT 1
685: FROM gms_budget_versions pbv,
686: gms_resource_assignments pra,
687: gms_budget_lines pbl
688: WHERE pbv.budget_version_id = pra.budget_version_id
689: AND pbv.project_id = P_PROJECT_ID
690: AND pra.resource_assignment_id = pbl.resource_assignment_id
691: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y')));

Line 836: gms_budget_lines pbl

832: CURSOR budget_lines_csr IS
833: SELECT 1
834: FROM gms_budget_versions pbv,
835: gms_resource_assignments pra,
836: gms_budget_lines pbl
837: WHERE pbv.budget_version_id = pra.budget_version_id
838: AND pbv.project_id = P_PROJECT_ID
839: AND pra.resource_assignment_id = pbl.resource_assignment_id
840: AND (pbv.budget_status_code = 'W' or (pbv.budget_status_code = 'B' and pbv.current_flag = 'Y'))