DBA Data[Home] [Help]

APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_EVENTS

Line 756: PA_EVENTS ev,

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
760: AND NVL(ERDL.AMOUNT, 0) <> 0

Line 1484: PA_EVENTS ev,

1480: mc.accounting_date accounting_date,
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