eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PAXMGURA_XMLP_PKG dependencies on PA_DRAFT_INVOICES

Line 230: PA_DRAFT_INVOICES PDI,

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

Line 231: PA_DRAFT_INVOICES PDI1,

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

Line 502: PA_DRAFT_INVOICES PDI,

498: FROM
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

Line 648: PA_DRAFT_INVOICES PDI

644: AND NOT EXISTS (
645: SELECT
646: 'x'
647: FROM
648: PA_DRAFT_INVOICES PDI
649: WHERE PCR.PROJECT_ID = PDI.PROJECT_ID
650: AND PCR.DRAFT_INVOICE_NUM = PDI.DRAFT_INVOICE_NUM
651: AND PDI.RELEASED_DATE IS NOT NULL )
652: AND PE.EVENT_TYPE = PET.EVENT_TYPE

Line 802: PA_DRAFT_INVOICES PDI

798: AND NOT EXISTS (
799: SELECT
800: 'x'
801: FROM
802: PA_DRAFT_INVOICES PDI
803: WHERE PCR.PROJECT_ID = PDI.PROJECT_ID
804: AND PCR.DRAFT_INVOICE_NUM = PDI.DRAFT_INVOICE_NUM
805: AND PDI.RELEASED_DATE IS NOT NULL )
806: AND PE.EVENT_TYPE = PET.EVENT_TYPE

Line 831: PA_DRAFT_INVOICES PDI,

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

Line 956: PA_DRAFT_INVOICES PDI,

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

Line 1011: PA_DRAFT_INVOICES PDI,

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

Line 1051: PA_DRAFT_INVOICES PDI,

1047: AND EXISTS (
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

Line 1070: PA_DRAFT_INVOICES PDI,

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
1074: AND PCR.DRAFT_INVOICE_NUM = pdi.draft_invoice_num (+)

Line 1103: PA_DRAFT_INVOICES PDI

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

Line 1173: PA_DRAFT_INVOICES PDI,

1169: NVL(PDII.EVENT_TASK_ID
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