APPS.PJI_RM_SUM_AVL dependencies on PJI_RM_RES_F

Line 1658: SELECT /*+ full(cur2) use_hash(cur2) index(fct, PJI_RM_RES_F_N2) */

1654: AVL_RES_COUNT_BKT3,
1655: AVL_RES_COUNT_BKT4,
1656: AVL_RES_COUNT_BKT5
1657: )
1658: SELECT /*+ full(cur2) use_hash(cur2) index(fct, PJI_RM_RES_F_N2) */
1659: cur2.worker_id as worker_id,
1660: fct.expenditure_organization_id,
1661: fct.expenditure_org_id,
1662: cur2.person_id as person_id,

Line 1904: PJI_RM_RES_F fct

1900: cur1.worker_id,
1901: cur1.person_id,
1902: cur1.time_id
1903: ) cur2,
1904: PJI_RM_RES_F fct
1905: WHERE
1906: cur2.time_id = fct.time_id
1907: and cur2.person_id = fct.person_id
1908: and 'C' = fct.calendar_type