DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_ACTUAL_PVT dependencies on PJI_FP_TXN_ACCUM

Line 340: PJI_FP_TXN_ACCUM accum,

336: ----------------------
337: nvl(accum.QUANTITY,0) QUANTITY,
338: nvl(accum.BILL_QUANTITY,0) BILL_QUANTITY
339: FROM
340: PJI_FP_TXN_ACCUM accum,
341: PA_RBS_TXN_ACCUM_MAP map1
342: WHERE project_id = p_project_id
343: AND p_calling_mode = 'FULL'
344: AND recvr_period_type = 'GL'

Line 399: PJI_FP_TXN_ACCUM1 accum1,

395: ----------------------
396: 0 QUANTITY,
397: 0 BILL_QUANTITY
398: FROM
399: PJI_FP_TXN_ACCUM1 accum1,
400: PA_RBS_TXN_ACCUM_MAP map1
401: WHERE project_id = p_project_id
402: AND p_calling_mode = 'FULL'
403: AND recvr_period_type = 'GL'

Line 588: PJI_FP_TXN_ACCUM accum

584: ----------------------
585: nvl(accum.QUANTITY,0) QUANTITY,
586: nvl(accum.BILL_QUANTITY,0) BILL_QUANTITY
587: FROM
588: PJI_FP_TXN_ACCUM accum
589: WHERE project_id = p_project_id
590: AND p_calling_mode = 'FULL'
591: AND recvr_period_type = 'GL'
592: UNION ALL

Line 644: PJI_FP_TXN_ACCUM1 accum1

640: ----------------------
641: 0 QUANTITY,
642: 0 BILL_QUANTITY
643: FROM
644: PJI_FP_TXN_ACCUM1 accum1
645: WHERE project_id = p_project_id
646: AND p_calling_mode = 'FULL'
647: AND recvr_period_type = 'GL'
648: ) tmp7 ,