APPS.GMS_AWARDS_DIST_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 626: from pa_expenditure_items_all ei

622: -- =====
623: delete from gms_award_distributions adls
624: where document_type = 'EXP'
625: and expenditure_item_id in ( select expenditure_item_id
626: from pa_expenditure_items_all ei
627: where expenditure_item_id = p_doc_distribution_id ) ;
628: ELSE
629:
630: -- =====

Line 636: from pa_expenditure_items_all ei

632: -- =====
633: delete from gms_award_distributions adls
634: where document_type = 'EXP'
635: and expenditure_item_id in ( select expenditure_item_id
636: from pa_expenditure_items_all ei
637: where expenditure_id = p_doc_header_id ) ;
638: END IF ;
639:
640: ELSIF p_doc_type = 'ENC' THEN

Line 709: -- in PA_EXPENDITURE_ITEMS_ALL

705: ***************************************************/
706: -- --------------------------------------------------------------
707: -- PROCEDURE update_billable_flag (p_expenditure_item_id in number)
708: -- This procedure will initialize the billable flag
709: -- in PA_EXPENDITURE_ITEMS_ALL
710: -- Called from trigger GMS_UPDATE_EI_BILLABLE_FLAG
711: -- on GMS_AWARD_DISTRIBUTIONS
712: -- this Procedure is created as direct update of
713: -- other products tables directly from trigger leads to warning in

Line 720: /* Update pa_expenditure_items_all

716: PROCEDURE update_billable_flag (p_expenditure_item_id in number)
717: IS
718: BEGIN
719: -- Commenting below code, Bug 1756179
720: /* Update pa_expenditure_items_all
721: set billable_flag = 'Y'
722: where expenditure_item_id = p_expenditure_item_id
723: and nvl(billable_flag ,'N') = 'N'; */
724: NULL; -- Added bug 1756179