APPS.PA_XLA_UPGRADE dependencies on PA_CC_DIST_LINES_ALL

Line 339: FROM PA_CC_DIST_LINES_ALL cdl,

335: 'Cross Charge Debit' DR_REFERENCE_3,
336: 'Cross Charge Credit' CR_REFERENCE_3,
337: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
338: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
339: FROM PA_CC_DIST_LINES_ALL cdl,
340: PA_EXPENDITURE_ITEMS_ALL ei,
341: PA_IMPLEMENTATIONS_ALL imp,
342: (select ledger_id,min(min_value) min_value, max(max_value) max_value from
343: PA_XLA_UPG_CTRL

Line 789: PA_CC_DIST_LINES_ALL cdl

785:
786:
787:
788: UPDATE /*+ INDEX(cdl, PA_CC_DIST_LINES_U2) */
789: PA_CC_DIST_LINES_ALL cdl
790: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
791: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
792: where cdl.expenditure_item_id = event_gt.expenditure_item_id
793: and cdl.gl_date = event_gt.event_date

Line 1161: PA_CC_DIST_LINES_ALL cdl,

1157: 'Cross Charge Credit' CR_REFERENCE_3,
1158: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
1159: to_char(cdl.cr_code_combination_id) CR_REFERENCE_2
1160: from PA_MC_CC_DIST_LINES_ALL mc,
1161: PA_CC_DIST_LINES_ALL cdl,
1162: PA_EXPENDITURE_ITEMS_ALL ei,
1163: PA_IMPLEMENTATIONS_ALL imp,
1164: XLA_EVENTS evt,
1165: HR_ORGANIZATION_INFORMATION hoi

Line 1696: FROM pa_cc_dist_lines_all ccdl

1692: End If;
1693:
1694: SELECT /*+ parallel(ccdl) */ nvl(min(expenditure_item_id),0), nvl(max(expenditure_item_id),0)
1695: INTO l_ccd_min_eiid, l_ccd_max_eiid
1696: FROM pa_cc_dist_lines_all ccdl
1697: WHERE gl_date between l_start_date and l_end_date
1698: AND transfer_status_code = 'A'
1699: AND acct_event_id is null
1700: AND gl_batch_name is not null;