APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_MC_DRAFT_REVS_ALL

Line 1214: pa_mc_draft_revs_all mc,

1210: imp.set_of_books_id ledger_id,
1211: decode(dr.draft_revenue_num_credited,null,'N','Y') adjusted_flag
1212: from pa_draft_revenues_all dr,
1213: pa_implementations_all imp,
1214: pa_mc_draft_revs_all mc,
1215: XLA_EVENTS evt,
1216: pa_xla_upg_ctrl gl,
1217: pa_projects_all pa,
1218: hr_organization_information hr

Line 1532: UPDATE PA_MC_DRAFT_REVS_ALL mc

1528: accounting_date,
1529: ledger_id
1530: FROM PA_XLA_LINES_TMP MC );
1531:
1532: UPDATE PA_MC_DRAFT_REVS_ALL mc
1533: SET mc.xla_migrated_flag = 'Y'
1534: WHERE mc.rowid >= p_start_rowid
1535: AND mc.rowid <= p_end_rowid
1536: AND nvl(xla_migrated_flag,'N') = 'N'

Line 1601: FROM PA_MC_DRAFT_REVS_ALL;

1597:
1598:
1599: SELECT MIN(ROWID), MAX(ROWID)
1600: INTO l_start_rowid, l_end_rowid
1601: FROM PA_MC_DRAFT_REVS_ALL;
1602:
1603:
1604: UPGRADE_MC_TRANSACTIONS(p_batch_id => l_batch_id,
1605: p_start_rowid => l_start_rowid,