APPS.PA_PAXMGURA_XMLP_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 232: PA_DRAFT_INVOICE_ITEMS PDII

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
234: ,0)
235: AND NVL(NULL
236: ,999999999999999)

Line 832: PA_DRAFT_INVOICE_ITEMS PDII

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)
835: AND NVL(P_ORG_ID
836: ,999999999999999)

Line 957: PA_DRAFT_INVOICE_ITEMS PDII

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)
960: AND NVL(P_ORG_ID
961: ,999999999999999)

Line 1012: PA_DRAFT_INVOICE_ITEMS PDII

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
1014: AND PDI.PROJECT_ID = PDII.PROJECT_ID
1015: AND PDI.PROJECT_ID = P.PROJECT_ID
1016: AND PDI.DRAFT_INVOICE_NUM = PDII.DRAFT_INVOICE_NUM

Line 1052: PA_DRAFT_INVOICE_ITEMS PDII

1048: SELECT
1049: 'event accepted'
1050: FROM
1051: PA_DRAFT_INVOICES PDI,
1052: PA_DRAFT_INVOICE_ITEMS PDII
1053: WHERE PDI.RELEASED_DATE IS NOT NULL
1054: AND PDI.PROJECT_ID = PDII.PROJECT_ID
1055: AND PDI.PROJECT_ID = P.PROJECT_ID
1056: AND PDI.DRAFT_INVOICE_NUM = PDII.DRAFT_INVOICE_NUM

Line 1174: PA_DRAFT_INVOICE_ITEMS PDII

1170: ,-1),
1171: PDII.EVENT_NUM
1172: FROM
1173: PA_DRAFT_INVOICES PDI,
1174: PA_DRAFT_INVOICE_ITEMS PDII
1175: WHERE PDI.RELEASED_DATE IS NOT NULL
1176: AND PDI.PROJECT_ID = PDII.PROJECT_ID
1177: AND PDI.PROJECT_ID = P.PROJECT_ID
1178: AND PDI.CANCELED_FLAG is null