APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_XLA_DRAFT_REV_TMP

Line 331: INTO PA_XLA_DRAFT_REV_TMP

327: 6,
328: adjusted_flag
329: )
330: WHEN 1= 1 THEN
331: INTO PA_XLA_DRAFT_REV_TMP
332: (REV_ROWID,
333: PROJECT_ID,
334: DRAFT_REVENUE_NUM,
335: AE_HEADER_ID,

Line 717: PA_XLA_DRAFT_REV_TMP DR

713: rownum row_num,
714: dr.accounting_date accounting_date,
715: dr.ledger_id ledger_id
716: FROM PA_CUST_REV_DIST_LINES_ALL CRDL,
717: PA_XLA_DRAFT_REV_TMP DR
718: WHERE DR.DRAFT_REVENUE_NUM = CRDL.DRAFT_REVENUE_NUM
719: AND DR.PROJECT_ID = CRDL.PROJECT_ID
720: /*AND NVL(CRDL.AMOUNT, 0) <> 0 Commented for Bug 10302541 */
721: AND crdl.code_combination_id is not null /*Bug 5455002*/

Line 755: PA_XLA_DRAFT_REV_TMP DR,

751: rownum row_num,
752: dr.accounting_date accounting_date,
753: dr.ledger_id ledger_id
754: FROM PA_CUST_EVENT_RDL_ALL ERDL,
755: PA_XLA_DRAFT_REV_TMP DR,
756: PA_EVENTS ev,
757: PA_EVENT_TYPES et
758: WHERE DR.DRAFT_REVENUE_NUM = ERDL.DRAFT_REVENUE_NUM
759: AND DR.PROJECT_ID = ERDL.PROJECT_ID

Line 798: from PA_XLA_DRAFT_REV_TMP tmp

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*/
801: dr.created_by =-99999
802: WHERE dr.rowid >= p_start_rowid

Line 807: FROM PA_XLA_DRAFT_REV_TMP tmp

803: AND dr.rowid <= p_end_rowid
804: AND dr.event_id is null
805: AND dr.transfer_Status_code='A'
806: AND EXISTS (SELECT 'X'
807: FROM PA_XLA_DRAFT_REV_TMP tmp
808: WHERE dr.rowid = tmp.rev_rowid);
809:
810: p_rows_process := p_rows_process + SQL%ROWCOUNT;
811:

Line 1102: INTO PA_XLA_DRAFT_REV_TMP

1098: gl_date,
1099: adjusted_flag
1100: )
1101: WHEN 1 = 1 THEN
1102: INTO PA_XLA_DRAFT_REV_TMP
1103: (REV_ROWID,
1104: PROJECT_ID,
1105: DRAFT_REVENUE_NUM,
1106: AE_HEADER_ID,

Line 1433: PA_XLA_DRAFT_REV_TMP MC

1429: mc.accounting_date accounting_date,
1430: mc.REP_SET_OF_BOOKS_ID ledger_id
1431: FROM PA_CUST_REV_DIST_LINES_ALL CRDL,
1432: PA_MC_CUST_RDL_ALL mcrdl,
1433: PA_XLA_DRAFT_REV_TMP MC
1434: WHERE mc.project_id = mcrdl.project_id
1435: AND mc.draft_revenue_num = mcrdl.draft_revenue_num
1436: AND mc.rep_set_of_books_id = mcrdl.set_of_books_id
1437: AND mcrdl.expenditure_item_id = crdl.expenditure_item_id

Line 1485: PA_XLA_DRAFT_REV_TMP MC,

1481: mc.REP_SET_OF_BOOKS_ID ledger_id
1482: FROM PA_CUST_EVENT_RDL_ALL erdl,
1483: PA_MC_CUST_EVENT_RDL_ALL mcerdl,
1484: PA_EVENTS ev,
1485: PA_XLA_DRAFT_REV_TMP MC,
1486: PA_EVENT_TYPES et
1487: WHERE mc.project_id = mcerdl.project_id
1488: AND mc.draft_revenue_num = mcerdl.draft_revenue_num
1489: AND mc.rep_set_of_books_id = mcerdl.set_of_books_id

Line 1539: FROM PA_XLA_DRAFT_REV_TMP tmp

1535: WHERE mc.rowid >= p_start_rowid
1536: AND mc.rowid <= p_end_rowid
1537: AND nvl(xla_migrated_flag,'N') = 'N'
1538: AND EXISTS (SELECT 'X'
1539: FROM PA_XLA_DRAFT_REV_TMP tmp
1540: WHERE mc.rowid = tmp.rev_rowid);
1541:
1542: p_rows_process := p_rows_process + SQL%ROWCOUNT;
1543: