DBA Data[Home] [Help]

APPS.GMS_PA_COSTING_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 2313: --pa_expenditure_items_all exp,

2309:
2310: cursor reversed_cur is
2311: select cdl.expenditure_item_id, cdl.line_num
2312: from pa_cost_distribution_lines cdl,
2313: --pa_expenditure_items_all exp,
2314: gms_bc_packets gbc
2315: where gbc.packet_id = g_packet_id
2316: and gbc.parent_bc_packet_id is null
2317: and gbc.status_code = 'A'

Line 2482: pa_expenditure_items_all exp,

2478: v_userid,
2479: v_date,
2480: v_login
2481: from pa_cost_distribution_lines cdl,
2482: pa_expenditure_items_all exp,
2483: gms_bc_packets gbc
2484: where gbc.packet_id = g_packet_id
2485: and exp.expenditure_item_id = cdl.expenditure_item_id
2486: and cdl.expenditure_item_id = gbc.document_header_id

Line 2601: pa_expenditure_items_all exp,

2597: v_userid,
2598: v_date,
2599: v_login
2600: from pa_cost_distribution_lines cdl,
2601: pa_expenditure_items_all exp,
2602: gms_bc_packets gbc
2603: where gbc.rowid = v_rowid(i)
2604: and exp.expenditure_item_id = cdl.expenditure_item_id
2605: and cdl.expenditure_item_id = gbc.document_header_id

Line 3346: pa_expenditure_items_all ei,

3342: v_userid,
3343: v_date,
3344: v_login
3345: from pa_transaction_interface_all txn,
3346: pa_expenditure_items_all ei,
3347: pa_cost_distribution_lines_all cdl,
3348: ap_invoice_distributions_all apd,
3349: gms_award_distributions adl
3350: where txn.interface_id = p_xface_id