APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_DRAFT_REVENUES_ALL

Line 525: from pa_draft_revenues_all dr,

521: dr.realized_losses_batch_name realized_losses_batch_name,
522: pa.projfunc_currency_code currency_code,
523: decode(dr.draft_revenue_num_credited,null,'N','Y') adjusted_flag,
524: pa.segment1||'-'||to_char(dr.draft_revenue_num) transaction_number
525: from pa_draft_revenues_all dr,
526: pa_implementations_all imp,
527: pa_xla_upg_ctrl gl,
528: pa_projects_all pa,
529: hr_organization_information hr/*Added for 4920063 */

Line 796: UPDATE PA_DRAFT_REVENUES_ALL dr

792: ledger_id
793: FROM PA_XLA_LINES_TMP DR);
794:
795:
796: UPDATE PA_DRAFT_REVENUES_ALL dr
797: SET dr.event_id = ( select tmp.xla_event_id
798: from PA_XLA_DRAFT_REV_TMP tmp
799: WHERE dr.rowid = tmp.rev_rowid),
800: dr.created_by =-99999

Line 1212: from pa_draft_revenues_all dr,

1208: pa.projfunc_currency_code currency_code,
1209: mc.transfer_status_code trans_status_code,
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,

Line 1588: FROM PA_DRAFT_REVENUES_ALL;

1584: FROM DUAL;
1585:
1586: SELECT MIN(ROWID), MAX(ROWID)
1587: INTO l_start_rowid, l_end_rowid
1588: FROM PA_DRAFT_REVENUES_ALL;
1589:
1590:
1591: UPGRADE_TRANSACTIONS(p_batch_id => l_batch_id,
1592: p_start_rowid => l_start_rowid,