APPS.PA_XLA_INTERFACE_PKG dependencies on PA_TRANSACTION_SOURCES

Line 197: from pa_transaction_sources

193: 'N', 'PA',
194: 'EXT'),
195: acct_source_code)
196: into l_acct_source
197: from pa_transaction_sources
198: where transaction_source = p_transaction_source;
199:
200: if l_acct_source like 'AP%' then
201: if p_payment_id is not null then

Line 655: pa_transaction_sources pts

651: pts.acct_source_code) pts_source,
652: cdl.cr_code_combination_id orig_cr_ccid
653: from pa_cost_distribution_lines_all cdl,
654: pa_expenditure_items_all exp,
655: pa_transaction_sources pts
656: where exp.expenditure_item_id = cdl.expenditure_item_id
657: and exp.transaction_source = pts.transaction_source(+)
658: and cdl.request_id = g_data_set_id
659: and cdl.transfer_status_code = 'X'

Line 700: pa_transaction_sources pts

696: from pa_cost_distribution_lines_all cdl,
697: pa_expenditure_items_all exp,
698: pa_expenditure_items_all pe,
699: pa_cost_distribution_lines_all cd,
700: pa_transaction_sources pts
701: where exp.expenditure_item_id = cdl.expenditure_item_id
702: and pe.transaction_source = pts.transaction_source(+)
703: and cdl.request_id = g_data_set_id
704: and cdl.transfer_status_code = 'X'

Line 743: pa_transaction_sources pts

739: cd.cr_code_combination_id orig_cr_ccid
740: from pa_cost_distribution_lines_all cdl,
741: pa_expenditure_items_all exp,
742: pa_cost_distribution_lines_all cd,
743: pa_transaction_sources pts
744: where exp.expenditure_item_id = cdl.expenditure_item_id
745: and exp.transaction_source = pts.transaction_source(+)
746: and cdl.request_id = g_data_set_id
747: and cdl.transfer_status_code = 'X'

Line 2232: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;

2228: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2229: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2230: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2231: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2232: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2233: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2234: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2235: l_acct_event_id XLA_Events.Event_ID%TYPE;
2236: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;

Line 2233: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;

2229: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2230: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2231: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2232: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2233: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2234: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2235: l_acct_event_id XLA_Events.Event_ID%TYPE;
2236: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;
2237: l_sys_ref5 PA_Cost_Distribution_Lines_All.system_reference5%TYPE;

Line 2285: FROM PA_Transaction_Sources ts

2281: THEN
2282: SELECT ts.Predefined_Flag, ts.Acct_Source_Code
2283: INTO l_predefined_flag
2284: ,l_acct_source_code
2285: FROM PA_Transaction_Sources ts
2286: WHERE Transaction_Source = P_Transaction_Source;
2287:
2288: -- AP_PAY is determined based on payment_id field being populated on
2289: -- EI. This is true for Case Basis Accounting and "AP Discounts" in