DBA Data[Home] [Help]

APPS.PA_PAXMGURA_XMLP_PKG dependencies on PA_DRAFT_REVENUES

Line 503: PA_DRAFT_REVENUES PDR

499: PA_TASKS T,
500: PA_EXPENDITURE_ITEMS_ALL PAI,
501: PA_CUST_REV_DIST_LINES PCR,
502: PA_DRAFT_INVOICES PDI,
503: PA_DRAFT_REVENUES PDR
504: WHERE T.PROJECT_ID = C1REC.PROJECT_ID
505: AND PDR.PROJECT_ID = C1REC.PROJECT_ID
506: AND T.TASK_ID = PAI.TASK_ID
507: AND PAI.EXPENDITURE_ITEM_ID = PCR.EXPENDITURE_ITEM_ID

Line 618: PA_DRAFT_REVENUES PDR,

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)
622: AND NVL(P_ORG_ID

Line 765: PA_DRAFT_REVENUES PDR,

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)
769: AND NVL(P_ORG_ID

Line 1069: PA_DRAFT_REVENUES PDR,

1065: AND EXISTS (
1066: SELECT
1067: 'event accepted'
1068: FROM
1069: PA_DRAFT_REVENUES PDR,
1070: PA_DRAFT_INVOICES PDI,
1071: PA_CUST_EVENT_REV_DIST_LINES PCR
1072: WHERE PDR.RELEASED_DATE IS NOT NULL
1073: AND PDR.PROJECT_ID = PCR.PROJECT_ID