DBA Data[Home] [Help]

APPS.PA_REVERSE_COSTED_LAB dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 914: -- and mark the CDF on pa_expenditure_items_all

910: -- Type : Public
911: -- Pre-Reqs : None
912: -- Type : Procedure
913: -- Function : Creates the reversal cdl for backout items
914: -- and mark the CDF on pa_expenditure_items_all
915:
916: --
917: --
918: --

Line 1035: FROM pa_expenditure_items_All ITEMS,

1031: ,l_org_id
1032: ,l_recvr_org_id
1033: ,l_sys_link_function
1034: ,l_exp_id
1035: FROM pa_expenditure_items_All ITEMS,
1036: pa_transaction_sources TRN
1037: WHERE ITEMS.transaction_source = TRN.transaction_source (+)
1038: AND ITEMS.expenditure_item_id = X_exp_item_id;
1039: SELECT imp1.set_of_books_id, imp2.set_of_books_id

Line 1295: INSERT INTO pa_expenditure_items_all(

1291: write_log(LOG, 'Inside createorigexpitem');
1292: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1293: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
1294: X_transfer_id := pa_utils.GetNextEiId;
1295: INSERT INTO pa_expenditure_items_all(
1296: expenditure_item_id
1297: , task_id
1298: , expenditure_type
1299: , system_linkage_function

Line 1538: pa_expenditure_items_all ei

1534: , null --ei.rate_source_code
1535: , null --ei.costing_method
1536: , NULL --PAYROLL_ACCRUAL_FLAG
1537: FROM
1538: pa_expenditure_items_all ei
1539: WHERE
1540: ei.expenditure_item_id = X_exp_item_id;
1541: /* Fix for bug 2211472 */
1542: /* Adding the comment of original expenditure_item to the TRANSFERED expenditure item