DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_EXPENDITURE_TYPES

Line 2285: pa_expenditure_types et,

2281: pobc.reference6, -- For GMSIP
2282: pobc.reference13 --Vendor id for GMSIP transactions
2283: FROM po_bc_distributions pobc ,
2284: psa_bc_xla_events_gt xlaevt,
2285: pa_expenditure_types et,
2286: gms_project_types gpt,
2287: pa_projects_all pp
2288: WHERE pobc.ae_event_id = xlaevt.event_id
2289: AND pobc.pa_project_id IS NOT NULL

Line 2736: pa_expenditure_types et

2732: apd.parent_reversal_id parent_reversal_id -- Bug 5369296
2733: FROM ap_invoice_distributions_all apd,
2734: ap_invoices_all api,
2735: gms_award_distributions adl,
2736: pa_expenditure_types et
2737: WHERE apd.invoice_distribution_id = p_ap_dist_id
2738: AND apd.project_id IS NOT NULL
2739: AND (NVL (apd.pa_addition_flag, 'X') <> 'T')
2740: AND NVL (apd.award_id, l_dist_award_id) = adl.award_set_id

Line 2784: PA_EXPENDITURE_TYPES ET

2780: apsat.PARENT_REVERSAL_ID PARENT_REVERSAL_ID
2781: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
2782: ap_invoices_all api,
2783: gms_award_distributions adl,
2784: PA_EXPENDITURE_TYPES ET
2785: WHERE apsat.invoice_distribution_id = p_ap_dist_id
2786: AND apsat.project_id IS NOT NULL
2787: and (NVL (APSAT.PA_ADDITION_FLAG, 'X') <> 'T')
2788: AND NVL (apsat.award_id, l_dist_award_id) = adl.award_set_id

Line 3733: pa_expenditure_types et,

3729: gbc.session_id,
3730: gbc.serial_id,
3731: gbc.txn_interface_id -- Bug 9929155
3732: FROM /*pa_ind_rate_sch_revisions irsr, Bug 5656276 */
3733: pa_expenditure_types et,
3734: pa_ind_cost_codes icc,
3735: pa_cost_base_cost_codes cbcc, -- Bug 5656276
3736: pa_cost_base_exp_types cbet,
3737: /*pa_ind_compiled_sets ics, Bug 5656276 */