DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on PA_TRANSACTION_SOURCES

Line 6082: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;

6078: p_project_id pa_cost_distribution_lines.project_id%TYPE;
6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;
6080: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
6081: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
6082: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
6083: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
6084: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
6085: p_err_code NUMBER;
6086: p_err_stage VARCHAR2(1000);

Line 6083: p_transaction_source pa_transaction_sources.transaction_source%TYPE;

6079: p_task_id pa_cost_distribution_lines.task_id%TYPE;
6080: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
6081: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
6082: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
6083: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
6084: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
6085: p_err_code NUMBER;
6086: p_err_stage VARCHAR2(1000);
6087: p_err_stack VARCHAR2(1000);

Line 6152: pa_transaction_sources TRN

6148: ,l_sys_link_function
6149: ,l_exp_id
6150:
6151: FROM pa_expenditure_items_All ITEMS,
6152: pa_transaction_sources TRN
6153: WHERE ITEMS.transaction_source = TRN.transaction_source (+)
6154: AND ITEMS.expenditure_item_id = X_exp_item_id;
6155:
6156: SELECT imp1.set_of_books_id, imp2.set_of_books_id