APPS.GMS_PA_COSTING_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

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

2401: and mod(gbc.document_distribution_id,2) = 0
2402: --and exp.cost_distributed_flag = 'Y'
2403: and cdl.reversed_flag = 'Y';
2404:
2405: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2406: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2407: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2408: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2409: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;

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

2402: --and exp.cost_distributed_flag = 'Y'
2403: and cdl.reversed_flag = 'Y';
2404:
2405: Type tab_billable_flag is table of pa_cost_distribution_lines_all.billable_flag%TYPE;
2406: Type tab_line_num is table of pa_cost_distribution_lines_all.line_num%TYPE;
2407: Type tab_rlmi is table of gms_bc_packets.resource_list_member_id%TYPE;
2408: Type tab_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
2409: Type tab_status_code is table of gms_bc_packets.status_code%TYPE;
2410: Type tab_row_id is table of varchar2(30);

Line 3430: pa_cost_distribution_lines_all cdl,

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