APPS.PJI_PJP_SUM_CUST dependencies on PJI_AC_AGGR_PJP0

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

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

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

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

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

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

Line 558: PJI_AC_AGGR_PJP0 pjp0

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