DBA Data[Home] [Help]

APPS.GMS_PA_COSTING_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 2393: --pa_expenditure_items_all exp,

2389:
2390: cursor reversed_cur is
2391: select cdl.expenditure_item_id, cdl.line_num
2392: from pa_cost_distribution_lines cdl,
2393: --pa_expenditure_items_all exp,
2394: gms_bc_packets gbc
2395: where gbc.packet_id = g_packet_id
2396: and gbc.parent_bc_packet_id is null
2397: and gbc.status_code = 'A'

Line 2562: pa_expenditure_items_all exp,

2558: v_userid,
2559: v_date,
2560: v_login
2561: from pa_cost_distribution_lines cdl,
2562: pa_expenditure_items_all exp,
2563: gms_bc_packets gbc
2564: where gbc.packet_id = g_packet_id
2565: and exp.expenditure_item_id = cdl.expenditure_item_id
2566: and cdl.expenditure_item_id = gbc.document_header_id

Line 2681: pa_expenditure_items_all exp,

2677: v_userid,
2678: v_date,
2679: v_login
2680: from pa_cost_distribution_lines cdl,
2681: pa_expenditure_items_all exp,
2682: gms_bc_packets gbc
2683: where gbc.rowid = v_rowid(i)
2684: and exp.expenditure_item_id = cdl.expenditure_item_id
2685: and cdl.expenditure_item_id = gbc.document_header_id

Line 3429: pa_expenditure_items_all ei,

3425: v_userid,
3426: v_date,
3427: v_login
3428: from pa_transaction_interface_all txn,
3429: pa_expenditure_items_all ei,
3430: pa_cost_distribution_lines_all cdl,
3431: ap_invoice_distributions_all apd,
3432: gms_award_distributions adl
3433: where txn.interface_id = p_xface_id