APPS.PJI_FM_SUM_BKLG dependencies on PJI_FM_AGGR_FIN9

Line 47: , PJI_FM_AGGR_FIN9 fin9

43: -- , to_date(min(fin9.RECVR_GL_TIME_ID),'J')
44: -- , to_date(min(fin9.RECVR_PA_TIME_ID),'J')
45: , sum(abs(fin9.POU_REVENUE))
46: from pji_pji_proj_batch_map map
47: , PJI_FM_AGGR_FIN9 fin9
48: where 1 = 1
49: and map.worker_id = p_worker_id
50: and fin9.project_id = map.project_id
51: -- temptemp should consider GL and PA seperately