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: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
267: PA_XLA_UPG_CTRL

Line 770: pa_cost_distribution_lines_all cdl

766: /* Now stamp back the event id on the cdl and ccdl tables. */
767:
768:
769: UPDATE /*+ INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1) */
770: pa_cost_distribution_lines_all cdl
771: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
772: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
773: where cdl.expenditure_item_id = event_gt.expenditure_item_id
774: and cdl.gl_date = event_gt.event_date

Line 1110: PA_COST_DISTRIBUTION_LINES_ALL cdl,

1106: 'Liability' CR_REFERENCE_3,
1107: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1108: to_char('-99') CR_REFERENCE_2
1109: from PA_MC_COST_DIST_LINES_ALL mc,
1110: PA_COST_DISTRIBUTION_LINES_ALL cdl,
1111: PA_EXPENDITURE_ITEMS_ALL ei,
1112: PA_IMPLEMENTATIONS_ALL imp,
1113: XLA_EVENTS evt,
1114: HR_ORGANIZATION_INFORMATION hoi

Line 1684: FROM pa_cost_distribution_lines_all cdl

1680: l_cost_cross := 0;
1681:
1682: SELECT /*+ parallel(cdl) */ nvl(min(expenditure_item_id),0), nvl(max(expenditure_item_id),0)
1683: INTO l_cdl_min_eiid, l_cdl_max_eiid
1684: FROM pa_cost_distribution_lines_all cdl
1685: WHERE gl_date between l_start_date and l_end_date
1686: AND transfer_status_code = 'A'
1687: AND acct_event_id is null
1688: AND batch_name is not null;