DBA Data[Home] [Help]

APPS.PJI_FM_SUM_PSI dependencies on PJI_FM_AGGR_ACT2

Line 2113: PJI_FM_AGGR_ACT2 tmp2

2109: tmp2.GP2_AR_APPR_INVOICE_AMOUNT,
2110: tmp2.GP2_AR_AMOUNT_DUE,
2111: tmp2.GP2_AR_AMOUNT_OVERDUE
2112: from
2113: PJI_FM_AGGR_ACT2 tmp2
2114: where
2115: tmp2.WORKER_ID = p_worker_id and
2116: tmp2.GL_PERIOD_NAME is not null and
2117: tmp2.PA_PERIOD_NAME is not null

Line 2263: PJI_FM_AGGR_ACT2 tmp2,

2259: tmp2.GP2_AR_APPR_INVOICE_AMOUNT,
2260: tmp2.GP2_AR_AMOUNT_DUE,
2261: tmp2.GP2_AR_AMOUNT_OVERDUE
2262: from
2263: PJI_FM_AGGR_ACT2 tmp2,
2264: PA_TIME_CAL_NAME gl_cal, /* Modified for bug 12979524 */
2265: GL_PERIODS gl_per,
2266: PA_PERIODS_ALL pa_per
2267: where