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

Line 806: FROM PA_XLA_DRAFT_REV_TMP tmp

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

Line 1101: INTO PA_XLA_DRAFT_REV_TMP

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

Line 1432: PA_XLA_DRAFT_REV_TMP MC

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

Line 1484: PA_XLA_DRAFT_REV_TMP MC,

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

Line 1538: FROM PA_XLA_DRAFT_REV_TMP tmp

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