APPS.PA_XLA_INTERFACE_PKG dependencies on PA_TRANSACTION_SOURCES

Line 202: from pa_transaction_sources

198: decode(posted_flag,
199: 'N', 'PA',
200: acct_source_code)) /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
201: into l_acct_source
202: from pa_transaction_sources
203: where transaction_source = p_transaction_source;
204:
205: if l_acct_source like 'AP%' then
206: if p_payment_id is not null then

Line 661: pa_transaction_sources pts

657: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
658: cdl.cr_code_combination_id orig_cr_ccid
659: from pa_cost_distribution_lines_all cdl,
660: pa_expenditure_items_all exp,
661: pa_transaction_sources pts
662: where exp.expenditure_item_id = cdl.expenditure_item_id
663: and exp.transaction_source = pts.transaction_source(+)
664: and cdl.request_id = g_data_set_id
665: and cdl.transfer_status_code = 'X'

Line 707: pa_transaction_sources pts

703: from pa_cost_distribution_lines_all cdl,
704: pa_expenditure_items_all exp,
705: pa_expenditure_items_all pe,
706: pa_cost_distribution_lines_all cd,
707: pa_transaction_sources pts
708: where exp.expenditure_item_id = cdl.expenditure_item_id
709: and pe.transaction_source = pts.transaction_source(+)
710: and cdl.request_id = g_data_set_id
711: and cdl.transfer_status_code = 'X'

Line 751: pa_transaction_sources pts

747: cd.cr_code_combination_id orig_cr_ccid
748: from pa_cost_distribution_lines_all cdl,
749: pa_expenditure_items_all exp,
750: pa_cost_distribution_lines_all cd,
751: pa_transaction_sources pts
752: where exp.expenditure_item_id = cdl.expenditure_item_id
753: and exp.transaction_source = pts.transaction_source(+)
754: and cdl.request_id = g_data_set_id
755: and cdl.transfer_status_code = 'X'

Line 2242: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;

2238: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2239: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2240: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2241: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2242: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2243: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2244: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2245: l_acct_event_id XLA_Events.Event_ID%TYPE;
2246: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;

Line 2243: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;

2239: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2240: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2241: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2242: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2243: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2244: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2245: l_acct_event_id XLA_Events.Event_ID%TYPE;
2246: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;
2247: l_sys_ref5 PA_Cost_Distribution_Lines_All.system_reference5%TYPE;

Line 2295: FROM PA_Transaction_Sources ts

2291: THEN
2292: SELECT ts.Predefined_Flag, ts.Acct_Source_Code
2293: INTO l_predefined_flag
2294: ,l_acct_source_code
2295: FROM PA_Transaction_Sources ts
2296: WHERE Transaction_Source = P_Transaction_Source;
2297:
2298: -- AP_PAY is determined based on payment_id field being populated on
2299: -- EI. This is true for Case Basis Accounting and "AP Discounts" in