APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on JE_IT_YEAR_EX_LIMIT

Line 1456: FROM je_it_year_ex_limit JIY,

1452: BEGIN
1453: l_starting_limit := 0;
1454: SELECT NVL(jiy.adjusted_limit_amount, 0)
1455: INTO l_starting_limit
1456: FROM je_it_year_ex_limit JIY,
1457: fnd_lookups fl
1458: WHERE fl.lookup_type = 'JEIT_MONTH'
1459: AND JIY.month = fl.lookup_code
1460: AND JIY.year = to_char(P_PERIOD,'RRRR')

Line 1482: FROM je_it_year_ex_limit JIY

1478: BEGIN
1479: l_adjustment_limit := 0;
1480: SELECT NVL(JIY.adjusted_limit_amount, 0)
1481: INTO l_adjustment_limit
1482: FROM je_it_year_ex_limit JIY
1483: WHERE JIY.year = to_char(P_PERIOD,'RRRR')
1484: AND JIY.month = to_char(P_PERIOD,'MM')
1485: AND JIY.legal_entity_id = P_LEGAL_ENTITY_ID ;
1486: fnd_file.put_line(fnd_file.log,'Adjustment Amount =>: '||l_adjustment_limit);