APPS.PA_XLA_UPGRADE dependencies on PA_MC_CC_DIST_LINES_ALL

Line 1160: from PA_MC_CC_DIST_LINES_ALL mc,

1156: 'Cross Charge Debit' DR_REFERENCE_3,
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,

Line 1477: pa_mc_cc_dist_lines_all mc

1473: and lines_gt.cdl_line_num = mc.line_num);
1474:
1475:
1476: UPDATE /*+ INDEX( mc, PA_MC_CC_DIST_LINES_U2) */
1477: pa_mc_cc_dist_lines_all mc
1478: SET mc.xla_migrated_flag = 'Y'
1479: WHERE mc.expenditure_item_id between l_start_eiid and l_end_eiid
1480: and mc.line_type in ('BL','PC')
1481: and exists ( select /*+ INDEX(lines_gt, PA_XLA_UPG_LINES_GT_N1) */