APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on PA_TASKS

Line 524: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */

520:
521: Procedure validate_proj_start_date( P_PROJECT_ID IN NUMBER,
522: P_START_DATE IN DATE,
523: X_MESSAGE OUT NOCOPY VARCHAR2,
524: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */
525:
526:
527: CURSOR budget_lines_csr IS
528: SELECT 1

Line 550: /* pa_tasks tsk 4138033 */

546: FROM DUAL
547: WHERE EXISTS
548: (SELECT 'X'
549: FROM pa_expenditure_items_all exp
550: /* pa_tasks tsk 4138033 */
551: WHERE /*exp.task_id = tsk.task_id
552: AND */ exp.project_id = P_PROJECT_ID
553: and exp.task_id = nvl(P_TASK_ID, exp.task_id)
554: AND exp.expenditure_item_date < P_START_DATE) ;

Line 562: pa_tasks tsk

558: FROM DUAL
559: WHERE EXISTS
560: (SELECT 'X'
561: FROM gms_encumbrance_items_all enc,
562: pa_tasks tsk
563: WHERE enc.task_id = tsk.task_id
564: AND tsk.project_id = P_PROJECT_ID
565: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)
566: -- ==============================================================

Line 587: pa_tasks tsk

583: WHERE EXISTS
584: (SELECT 'X'
585: FROM gms_encumbrance_items_all enc1,
586: gms_encumbrance_items_all enc2,
587: pa_tasks tsk
588: WHERE enc1.task_id = tsk.task_id
589: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
590: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'
591: AND NVL(enc2.net_zero_adjustment_flag,'N') = 'Y'

Line 608: --Bug 3985177 : Removed pa_tasks join in po_items_csr

604: WHERE po.project_id = P_PROJECT_ID
605: AND po.task_id = nvl(P_TASK_ID, po.task_id)
606: AND po.expenditure_item_date < P_START_DATE) ;
607:
608: --Bug 3985177 : Removed pa_tasks join in po_items_csr
609:
610: CURSOR ap_items_csr IS
611: SELECT 1
612: FROM DUAL

Line 620: --Bug 3985177 : Removed pa_tasks join in ap_items_csr

616: WHERE ap.project_id = P_PROJECT_ID
617: AND ap.task_id = nvl(P_TASK_ID, ap.task_id)
618: AND ap.expenditure_item_date < P_START_DATE) ;
619:
620: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
621:
622: CURSOR req_items_csr IS
623: SELECT 1
624: FROM DUAL

Line 632: --Bug 3985177 : Removed pa_tasks join in req_items_csr

628: WHERE req.project_id = P_PROJECT_ID
629: AND req.task_id = nvl(P_TASK_ID, req.task_id)
630: AND req.expenditure_item_date < P_START_DATE) ;
631:
632: --Bug 3985177 : Removed pa_tasks join in req_items_csr
633:
634: CURSOR budget_lines_exist_csr IS
635: SELECT 1
636: FROM DUAL

Line 784: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */

780:
781: Procedure validate_proj_completion_date( P_PROJECT_ID IN NUMBER,
782: P_COMPLETION_DATE IN DATE,
783: X_MESSAGE OUT NOCOPY VARCHAR2,
784: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */
785:
786: CURSOR budget_lines_csr IS
787: SELECT 1
788: FROM gms_budget_versions pbv,

Line 804: /* pa_tasks tsk */

800: FROM DUAL
801: WHERE EXISTS
802: (SELECT 'X'
803: FROM pa_expenditure_items_all exp
804: /* pa_tasks tsk */
805: WHERE /* exp.task_id = tsk.task_id
806: AND */ exp.project_id = P_PROJECT_ID
807: AND exp.task_id = nvl(P_TASK_ID, exp.task_id)
808: AND exp.expenditure_item_date > P_COMPLETION_DATE) ;

Line 816: pa_tasks tsk

812: FROM DUAL
813: WHERE EXISTS
814: (SELECT 'X'
815: FROM gms_encumbrance_items_all enc,
816: pa_tasks tsk
817: WHERE enc.task_id = tsk.task_id
818: AND tsk.project_id = P_PROJECT_ID
819: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)
820: -- ==============================================================

Line 840: pa_tasks tsk

836: WHERE EXISTS
837: (SELECT 'X'
838: FROM gms_encumbrance_items_all enc1,
839: gms_encumbrance_items_all enc2,
840: pa_tasks tsk
841: WHERE enc1.task_id = tsk.task_id
842: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
843: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'
844: AND NVL(enc2.net_zero_adjustment_flag,'N') = 'Y'

Line 861: --Bug 3985177 : Removed pa_tasks join in po_items_csr

857: WHERE po.project_id = P_PROJECT_ID
858: AND po.task_id = nvl(P_TASK_ID, po.task_id)
859: AND po.expenditure_item_date > P_COMPLETION_DATE) ;
860:
861: --Bug 3985177 : Removed pa_tasks join in po_items_csr
862:
863: CURSOR ap_items_csr IS
864: SELECT 1
865: FROM DUAL

Line 873: --Bug 3985177 : Removed pa_tasks join in ap_items_csr

869: WHERE ap.project_id = P_PROJECT_ID
870: AND ap.task_id = nvl(P_TASK_ID, ap.task_id)
871: AND ap.expenditure_item_date > P_COMPLETION_DATE) ;
872:
873: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
874:
875: CURSOR req_items_csr IS
876: SELECT 1
877: FROM DUAL

Line 885: --Bug 3985177 : Removed pa_tasks join in req_items_csr

881: WHERE req.project_id = P_PROJECT_ID
882: AND req.task_id = nvl(P_TASK_ID, req.task_id)
883: AND req.expenditure_item_date > P_COMPLETION_DATE) ;
884:
885: --Bug 3985177 : Removed pa_tasks join in req_items_csr
886:
887: l_budget_lines NUMBER ;
888: l_exp_items NUMBER ;
889: l_enc_items NUMBER ;