DBA Data[Home] [Help]

APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_EVENT_TYPES

Line 757: PA_EVENT_TYPES et

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
761: AND erdl.project_id = ev.project_id

Line 1485: PA_EVENT_TYPES et

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
1489: AND NVL(mcerdl.amount, 0) <> 0