APPS.PA_REVERSE_COSTED_LAB dependencies on PA_TRANSACTION_SOURCES

Line 690: pa_transaction_sources txs

686: l_trx_source_costed,
687: l_ALLOW_ADJUSTMENTS_FLAG
688: FROM
689: pa_expenditure_items ei ,
690: pa_transaction_sources txs
691: WHERE ei.transaction_source = txs.transaction_source(+)
692: AND ei.expenditure_item_id = X_expenditure_item_id;
693: IF l_trx_source_costed ='N' AND l_ALLOW_ADJUSTMENTS_FLAG='Y' THEN
694: l_is_ei_reversable :='Y';

Line 973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;

969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
974: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
975: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
976: p_err_code NUMBER;
977: p_err_stage VARCHAR2(1000);

Line 974: p_transaction_source pa_transaction_sources.transaction_source%TYPE;

970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
974: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
975: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
976: p_err_code NUMBER;
977: p_err_stage VARCHAR2(1000);
978: p_err_stack VARCHAR2(1000);

Line 1036: pa_transaction_sources TRN

1032: ,l_recvr_org_id
1033: ,l_sys_link_function
1034: ,l_exp_id
1035: FROM pa_expenditure_items_All ITEMS,
1036: pa_transaction_sources TRN
1037: WHERE ITEMS.transaction_source = TRN.transaction_source (+)
1038: AND ITEMS.expenditure_item_id = X_exp_item_id;
1039: SELECT imp1.set_of_books_id, imp2.set_of_books_id
1040: INTO l_sob_id, l_recvr_sob_id