APPS.PA_PAXMGURA_XMLP_PKG dependencies on PA_PROJECT_PLAYERS

Line 229: PA_PROJECT_PLAYERS PL,

225: ,0))
226: ,0)
227: FROM
228: PA_PROJECTS P,
229: PA_PROJECT_PLAYERS PL,
230: PA_DRAFT_INVOICES PDI,
231: PA_DRAFT_INVOICES PDI1,
232: PA_DRAFT_INVOICE_ITEMS PDII
233: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(NULL

Line 371: PA_PROJECT_PLAYERS PL

367: DISTINCT
368: P.PROJECT_ID
369: FROM
370: PA_PROJECTS P,
371: PA_PROJECT_PLAYERS PL
372: WHERE P.CARRYING_OUT_ORGANIZATION_ID BETWEEN NVL(P_ORG_ID
373: ,0)
374: AND NVL(P_ORG_ID
375: ,999999999999999)

Line 615: PA_PROJECT_PLAYERS PL,

611: ,0)
612: ,0))
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

Line 762: PA_PROJECT_PLAYERS PL,

758: ,0)
759: ,0))
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

Line 830: PA_PROJECT_PLAYERS PL,

826: SELECT
827: 1
828: FROM
829: PA_PROJECTS P,
830: PA_PROJECT_PLAYERS PL,
831: PA_DRAFT_INVOICES PDI,
832: PA_DRAFT_INVOICE_ITEMS PDII
833: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID
834: ,0)

Line 955: PA_PROJECT_PLAYERS PL,

951: ,0)
952: ,0)) * - 1
953: FROM
954: PA_PROJECTS P,
955: PA_PROJECT_PLAYERS PL,
956: PA_DRAFT_INVOICES PDI,
957: PA_DRAFT_INVOICE_ITEMS PDII
958: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID
959: ,0)

Line 1008: PA_PROJECT_PLAYERS PL,

1004: ,TO_CHAR(NVL(PDII.PROJFUNC_BILL_AMOUNT
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

Line 1101: PA_PROJECT_PLAYERS PL,

1097: COST_WORK_AMOUNT = (SELECT
1098: SUM(PCR.PROJFUNC_BILL_AMOUNT)
1099: FROM
1100: PA_PROJECTS P,
1101: PA_PROJECT_PLAYERS PL,
1102: PA_CUST_REV_DIST_LINES PCR,
1103: PA_DRAFT_INVOICES PDI
1104: WHERE P.CARRYING_OUT_ORGANIZATION_ID between NVL(P_ORG_ID
1105: ,0)

Line 1140: PA_PROJECT_PLAYERS PL,

1136: INVOICE_REDUCTION = (SELECT
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)