APPS.GMS_AWARDS_DIST_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 606: from pa_expenditure_items_all ei

602: -- =====
603: delete from gms_award_distributions adls
604: where document_type = 'EXP'
605: and expenditure_item_id in ( select expenditure_item_id
606: from pa_expenditure_items_all ei
607: where expenditure_item_id = p_doc_distribution_id ) ;
608: ELSE
609:
610: -- =====

Line 616: from pa_expenditure_items_all ei

612: -- =====
613: delete from gms_award_distributions adls
614: where document_type = 'EXP'
615: and expenditure_item_id in ( select expenditure_item_id
616: from pa_expenditure_items_all ei
617: where expenditure_id = p_doc_header_id ) ;
618: END IF ;
619:
620: ELSIF p_doc_type = 'ENC' THEN

Line 689: -- in PA_EXPENDITURE_ITEMS_ALL

685: ***************************************************/
686: -- --------------------------------------------------------------
687: -- PROCEDURE update_billable_flag (p_expenditure_item_id in number)
688: -- This procedure will initialize the billable flag
689: -- in PA_EXPENDITURE_ITEMS_ALL
690: -- Called from trigger GMS_UPDATE_EI_BILLABLE_FLAG
691: -- on GMS_AWARD_DISTRIBUTIONS
692: -- this Procedure is created as direct update of
693: -- other products tables directly from trigger leads to warning in

Line 700: /* Update pa_expenditure_items_all

696: PROCEDURE update_billable_flag (p_expenditure_item_id in number)
697: IS
698: BEGIN
699: -- Commenting below code, Bug 1756179
700: /* Update pa_expenditure_items_all
701: set billable_flag = 'Y'
702: where expenditure_item_id = p_expenditure_item_id
703: and nvl(billable_flag ,'N') = 'N'; */
704: NULL; -- Added bug 1756179