[Home] [Help]
546: NULL orig_historic,
547: NULL orig_dist_line_id,
548: NULL orig_acct_source
549: from pa_cc_dist_lines_all cdl,
550: pa_expenditure_items_all exp
551: where exp.expenditure_item_id = cdl.expenditure_item_id
552: and cdl.request_id = g_data_set_id
553: and cdl.transfer_status_code = 'X'
554: and cdl.dist_line_id_reversed is null
566: nvl(pe.historical_flag, 'Y') orig_historic,
567: cd.cc_dist_line_id orig_dist_line_id,
568: cd.acct_source_code orig_acct_source
569: from pa_cc_dist_lines_all cdl,
570: pa_expenditure_items_all exp,
571: pa_expenditure_items_all pe,
572: pa_cc_dist_lines_all cd
573: where exp.expenditure_item_id = cdl.expenditure_item_id
574: and cdl.request_id = g_data_set_id
567: cd.cc_dist_line_id orig_dist_line_id,
568: cd.acct_source_code orig_acct_source
569: from pa_cc_dist_lines_all cdl,
570: pa_expenditure_items_all exp,
571: pa_expenditure_items_all pe,
572: pa_cc_dist_lines_all cd
573: where exp.expenditure_item_id = cdl.expenditure_item_id
574: and cdl.request_id = g_data_set_id
575: and cdl.transfer_status_code = 'X'
590: NULL orig_historic,
591: cd.cc_dist_line_id orig_dist_line_id,
592: cd.acct_source_code orig_acct_source
593: from pa_cc_dist_lines_all cdl,
594: pa_expenditure_items_all exp,
595: pa_cc_dist_lines_all cd
596: where exp.expenditure_item_id = cdl.expenditure_item_id
597: and cdl.request_id = g_data_set_id
598: and cdl.transfer_status_code = 'X'
656: decode(pts.posted_flag,
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
700: decode(pts.posted_flag,
701: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
702: cd.cr_code_combination_id orig_cr_ccid
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
701: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
702: cd.cr_code_combination_id orig_cr_ccid
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(+)
745: decode(pts.posted_flag,
746: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
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(+)
2223:
2224: FUNCTION Get_Post_Acc_Sla_Ccid(
2225: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
2226: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2227: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2228: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2229: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2230: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2231: ,P_Distribution_Type IN VARCHAR2
2224: FUNCTION Get_Post_Acc_Sla_Ccid(
2225: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
2226: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2227: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2228: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2229: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2230: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2231: ,P_Distribution_Type IN VARCHAR2
2232: ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
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;
2248: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2249: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;
2250: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;
2251: l_payment_dist_lookup_code varchar2(15);
2252: BEGIN
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;
2248: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2249: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;
2250: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;
2251: l_payment_dist_lookup_code varchar2(15);
2252: BEGIN
2253:
2278: l_sys_ref5,
2279: l_document_distribution_id,
2280: l_document_payment_id
2281: from pa_cost_distribution_lines_all cd,
2282: pa_expenditure_items_all pe
2283: where cd.expenditure_item_id = pe.expenditure_item_id
2284: and cd.expenditure_item_id = p_distribution_id_1
2285: and cd.line_num = p_distribution_id_2;
2286: