DBA Data[Home] [Help]

APPS.PA_PAXMGURA_XMLP_PKG dependencies on PA_EVENT_TYPES

Line 617: PA_EVENT_TYPES PET,

613: FROM
614: PA_PROJECTS P,
615: PA_PROJECT_PLAYERS PL,
616: PA_EVENTS PE,
617: PA_EVENT_TYPES PET,
618: PA_DRAFT_REVENUES PDR,
619: PA_CUST_EVENT_REV_DIST_LINES PCR
620: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID
621: ,0)

Line 764: PA_EVENT_TYPES PET,

760: FROM
761: PA_PROJECTS P,
762: PA_PROJECT_PLAYERS PL,
763: PA_EVENTS PE,
764: PA_EVENT_TYPES PET,
765: PA_DRAFT_REVENUES PDR,
766: PA_CUST_EVENT_REV_DIST_LINES PCR
767: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID
768: ,0)

Line 1009: PA_EVENT_TYPES PET,

1005: ,0)))))
1006: FROM
1007: PA_PROJECTS P,
1008: PA_PROJECT_PLAYERS PL,
1009: PA_EVENT_TYPES PET,
1010: PA_EVENTS PE,
1011: PA_DRAFT_INVOICES PDI,
1012: PA_DRAFT_INVOICE_ITEMS PDII
1013: WHERE PDI.RELEASED_DATE IS NOT NULL

Line 1141: PA_EVENT_TYPES PET,

1137: SUM(PE.PROJFUNC_BILL_AMOUNT)
1138: FROM
1139: PA_PROJECTS P,
1140: PA_PROJECT_PLAYERS PL,
1141: PA_EVENT_TYPES PET,
1142: PA_EVENTS PE
1143: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID
1144: ,0)
1145: AND NVL(P_ORG_ID