APPS.PA_XLA_UPGRADE dependencies on PA_IMPLEMENTATIONS_ALL

Line 265: PA_IMPLEMENTATIONS_ALL imp,

261: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
262: to_char('-99') CR_REFERENCE_2
263: FROM PA_COST_DISTRIBUTION_LINES_ALL cdl,
264: PA_EXPENDITURE_ITEMS_ALL ei,
265: PA_IMPLEMENTATIONS_ALL imp,
266: PA_XLA_UPG_CTRL ctrl,
267: HR_ORGANIZATION_INFORMATION hoi
268: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
269: AND cdl.transfer_status_code = 'A'

Line 336: PA_IMPLEMENTATIONS_ALL imp,

332: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
333: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
334: FROM PA_CC_DIST_LINES_ALL cdl,
335: PA_EXPENDITURE_ITEMS_ALL ei,
336: PA_IMPLEMENTATIONS_ALL imp,
337: PA_XLA_UPG_CTRL ctrl,
338: HR_ORGANIZATION_INFORMATION hoi
339: WHERE cdl.expenditure_item_id between l_start_eiid and l_end_eiid
340: AND cdl.transfer_status_code = 'A'

Line 1101: PA_IMPLEMENTATIONS_ALL imp,

1097: to_char('-99') CR_REFERENCE_2
1098: from PA_MC_COST_DIST_LINES_ALL mc,
1099: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1100: PA_EXPENDITURE_ITEMS_ALL ei,
1101: PA_IMPLEMENTATIONS_ALL imp,
1102: XLA_EVENTS evt,
1103: HR_ORGANIZATION_INFORMATION hoi
1104: where mc.expenditure_item_id = cdl.expenditure_item_id
1105: and mc.line_num = cdl.line_num

Line 1152: PA_IMPLEMENTATIONS_ALL imp,

1148: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
1149: from PA_MC_CC_DIST_LINES_ALL mc,
1150: PA_CC_DIST_LINES_ALL cdl,
1151: PA_EXPENDITURE_ITEMS_ALL ei,
1152: PA_IMPLEMENTATIONS_ALL imp,
1153: XLA_EVENTS evt,
1154: HR_ORGANIZATION_INFORMATION hoi
1155: where mc.expenditure_item_id = cdl.expenditure_item_id
1156: and mc.line_num = cdl.line_num

Line 1598: from pa_implementations_all

1594: AND per1.ledger_id = per.ledger_id
1595: AND (per1.start_date between per.start_date and per.end_date OR
1596: per1.end_date between per.start_date and per.end_date)
1597: AND EXISTS ( Select null
1598: from pa_implementations_all
1599: where set_of_books_id = per.ledger_id);
1600:
1601:
1602: INSERT INTO PA_PRIM_REP_LEGER_tmp (prim_ledger_id,

Line 1612: pa_implementations_all imp

1608: per.period_name,
1609: p_batch_id
1610: FROM PA_PRIM_REP_LEGER_tmp per,
1611: gl_mc_reporting_options_11i mc,
1612: pa_implementations_all imp
1613: WHERE per.prim_ledger_id = mc.primary_set_of_books_id
1614: AND mc.application_id = 275
1615: AND imp.org_id = mc.org_id;
1616: