APPS.PA_XLA_UPGRADE dependencies on PA_CC_DIST_LINES_ALL

Line 334: FROM PA_CC_DIST_LINES_ALL cdl,

330: 'Cross Charge Debit' DR_REFERENCE_3,
331: 'Cross Charge Credit' CR_REFERENCE_3,
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

Line 779: PA_CC_DIST_LINES_ALL cdl

775:
776:
777:
778: UPDATE /*+ INDEX(cdl, PA_CC_DIST_LINES_U2) */
779: PA_CC_DIST_LINES_ALL cdl
780: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
781: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
782: where cdl.expenditure_item_id = event_gt.expenditure_item_id
783: and cdl.gl_date = event_gt.event_date

Line 1150: PA_CC_DIST_LINES_ALL cdl,

1146: 'Cross Charge Credit' CR_REFERENCE_3,
1147: to_char(cdl.dr_code_combination_id) DR_REFERENCE_2,
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

Line 1666: FROM pa_cc_dist_lines_all ccdl

1662: End If;
1663:
1664: SELECT /*+ parallel(ccdl) */ nvl(min(expenditure_item_id),0), nvl(max(expenditure_item_id),0)
1665: INTO l_ccd_min_eiid, l_ccd_max_eiid
1666: FROM pa_cc_dist_lines_all ccdl
1667: WHERE gl_date between l_start_date and l_end_date
1668: AND transfer_status_code = 'A'
1669: AND acct_event_id is null
1670: AND gl_batch_name is not null;