DBA Data[Home] [Help]

APPS.GMS_PA_COSTING_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 2325: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;

2321: and mod(gbc.document_distribution_id,2) = 0
2322: --and exp.cost_distributed_flag = 'Y'
2323: and cdl.reversed_flag = 'Y';
2324:
2325: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2326: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2327: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2328: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2329: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;

Line 2326: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;

2322: --and exp.cost_distributed_flag = 'Y'
2323: and cdl.reversed_flag = 'Y';
2324:
2325: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2326: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2327: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2328: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2329: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2330: Type tab_row_id is table of varchar2(30);

Line 3347: pa_cost_distribution_lines_all cdl,

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
3351: and nvl(txn.transaction_status_code, 'Z') <> 'R'