APPS.PA_XLA_UPGRADE dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 263: FROM PA_COST_DISTRIBUTION_LINES_ALL cdl,

259: 'Cost' DR_REFERENCE_3,
260: 'Liability' CR_REFERENCE_3,
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

Line 760: pa_cost_distribution_lines_all cdl

756: /* Now stamp back the event id on the cdl and ccdl tables. */
757:
758:
759: UPDATE /*+ INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1) */
760: pa_cost_distribution_lines_all cdl
761: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
762: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
763: where cdl.expenditure_item_id = event_gt.expenditure_item_id
764: and cdl.gl_date = event_gt.event_date

Line 1099: PA_COST_DISTRIBUTION_LINES_ALL cdl,

1095: 'Liability' CR_REFERENCE_3,
1096: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
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

Line 1654: FROM pa_cost_distribution_lines_all cdl

1650: l_cost_cross := 0;
1651:
1652: SELECT /*+ parallel(cdl) */ nvl(min(expenditure_item_id),0), nvl(max(expenditure_item_id),0)
1653: INTO l_cdl_min_eiid, l_cdl_max_eiid
1654: FROM pa_cost_distribution_lines_all cdl
1655: WHERE gl_date between l_start_date and l_end_date
1656: AND transfer_status_code = 'A'
1657: AND acct_event_id is null
1658: AND batch_name is not null;