APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_MC_DRAFT_REVS_ALL

Line 1215: pa_mc_draft_revs_all mc,

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

Line 1533: UPDATE PA_MC_DRAFT_REVS_ALL mc

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

Line 1602: FROM PA_MC_DRAFT_REVS_ALL;

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