[Home] [Help]
541: NULL orig_historic,
542: NULL orig_dist_line_id,
543: NULL orig_acct_source
544: from pa_cc_dist_lines_all cdl,
545: pa_expenditure_items_all exp
546: where exp.expenditure_item_id = cdl.expenditure_item_id
547: and cdl.request_id = g_data_set_id
548: and cdl.transfer_status_code = 'X'
549: and cdl.dist_line_id_reversed is null
561: nvl(pe.historical_flag, 'Y') orig_historic,
562: cd.cc_dist_line_id orig_dist_line_id,
563: cd.acct_source_code orig_acct_source
564: from pa_cc_dist_lines_all cdl,
565: pa_expenditure_items_all exp,
566: pa_expenditure_items_all pe,
567: pa_cc_dist_lines_all cd
568: where exp.expenditure_item_id = cdl.expenditure_item_id
569: and cdl.request_id = g_data_set_id
562: cd.cc_dist_line_id orig_dist_line_id,
563: cd.acct_source_code orig_acct_source
564: from pa_cc_dist_lines_all cdl,
565: pa_expenditure_items_all exp,
566: pa_expenditure_items_all pe,
567: pa_cc_dist_lines_all cd
568: where exp.expenditure_item_id = cdl.expenditure_item_id
569: and cdl.request_id = g_data_set_id
570: and cdl.transfer_status_code = 'X'
585: NULL orig_historic,
586: cd.cc_dist_line_id orig_dist_line_id,
587: cd.acct_source_code orig_acct_source
588: from pa_cc_dist_lines_all cdl,
589: pa_expenditure_items_all exp,
590: pa_cc_dist_lines_all cd
591: where exp.expenditure_item_id = cdl.expenditure_item_id
592: and cdl.request_id = g_data_set_id
593: and cdl.transfer_status_code = 'X'
650: 'N', 'PA', 'EXT'),
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
693: 'EXT'),
694: pts.acct_source_code) pts_source,
695: cd.cr_code_combination_id orig_cr_ccid
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
694: pts.acct_source_code) pts_source,
695: cd.cr_code_combination_id orig_cr_ccid
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(+)
737: 'EXT'),
738: pts.acct_source_code) pts_source,
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(+)
2213:
2214: FUNCTION Get_Post_Acc_Sla_Ccid(
2215: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
2216: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2217: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2218: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2219: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2220: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2221: ,P_Distribution_Type IN VARCHAR2
2214: FUNCTION Get_Post_Acc_Sla_Ccid(
2215: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
2216: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2217: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2218: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2219: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2220: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2221: ,P_Distribution_Type IN VARCHAR2
2222: ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
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;
2238: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2239: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;
2240: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;
2241: l_payment_dist_lookup_code varchar2(15);
2242: BEGIN
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;
2238: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2239: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;
2240: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;
2241: l_payment_dist_lookup_code varchar2(15);
2242: BEGIN
2243:
2268: l_sys_ref5,
2269: l_document_distribution_id,
2270: l_document_payment_id
2271: from pa_cost_distribution_lines_all cd,
2272: pa_expenditure_items_all pe
2273: where cd.expenditure_item_id = pe.expenditure_item_id
2274: and cd.expenditure_item_id = p_distribution_id_1
2275: and cd.line_num = p_distribution_id_2;
2276: