APPS.PJI_PJP_SUM_CUST dependencies on PJI_AC_AGGR_PJP0

Line 369: * AC BASIS TABLE ( I.E. PJI_AC_AGGR_PJP0) *

365: /**************************************************************************************************************
366: * Sample code with steps to customize custom measures for AC CUSTOM MEASURE TABLE(i.e.PJI_AC_CUST_PJP0) table*
367: * *
368: * *
369: * AC BASIS TABLE ( I.E. PJI_AC_AGGR_PJP0) *
370: * -------------------------------------- *
371: * This table is the first aggregation point after the transaction accum tables and provides a basis for *
372: * custom measures. This table has to be populated to store customized measures. It holds the mandatory *
373: * keys, which are being used, in custom table (i.e. PJI_AC_CUST_PJP0) to store customized measures. *

Line 378: * 1. Basis Table PJI_AC_AGGR_PJP0 should be populated *

374: * To see the definition of this table and its columns, please refer ETRM. *
375: * *
376: * MANDOTORY PREREQUISTE TO DEFINE CUSTOM MEASURE *
377: * --------------------------------------------- *
378: * 1. Basis Table PJI_AC_AGGR_PJP0 should be populated *
379: * WHAT IF AC BASIS TABLE IS NOT POPULATED *
380: * -------------------------------------- *
381: * If the basis table is not populated then the program will not use and store the customized measures *
382: * at all.

Line 484: * PJI_AC_AGGR_PJP0 pjp0 -- AC basis table, *

480: * TO_NUMBER(NULL) CUSTOM13, *
481: * TO_NUMBER(NULL) CUSTOM14, *
482: * TO_NUMBER(NULL) CUSTOM15 *
483: * FROM *
484: * PJI_AC_AGGR_PJP0 pjp0 -- AC basis table, *
485: * WHERE *
486: * pjp0.WORKER_ID = p_worker_id AND *
487: * pjp0.CURRENCY_CODE = 'USD' AND *
488: * pjp0.CALENDAR_TYPE = 'PA; *

Line 560: PJI_AC_AGGR_PJP0 pjp0

556: TO_NUMBER(NULL) CUSTOM13,
557: TO_NUMBER(NULL) CUSTOM14,
558: TO_NUMBER(NULL) CUSTOM15
559: FROM
560: PJI_AC_AGGR_PJP0 pjp0
561: WHERE
562: pjp0.WORKER_ID = p_worker_id AND
563: 1 = 2;
564: