[Home] [Help]
7:
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
231:
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
481: select gra.resource_list_member_id,
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:
544:
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
682: FROM DUAL
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
831:
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