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: and rownum = 1), /*bug 9972513*/

Line 1213: from pa_draft_revenues_all dr,

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

Line 1589: FROM PA_DRAFT_REVENUES_ALL;

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