APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on JE_IT_YEAR_EX_LIMIT

Line 2692: FROM je_it_year_ex_limit JIY,

2688:
2689: l_starting_limit := 0;
2690: SELECT NVL(jiy.adjusted_limit_amount, 0)
2691: INTO l_starting_limit
2692: FROM je_it_year_ex_limit JIY,
2693: fnd_lookups fl
2694: WHERE fl.lookup_type = 'JEIT_MONTH'
2695: AND JIY.month = fl.lookup_code
2696: AND JIY.year = to_char(l_period_date,'RRRR')

Line 2726: FROM je_it_year_ex_limit JIY

2722:
2723: l_adjustment_limit := 0;
2724: SELECT NVL(JIY.adjusted_limit_amount, 0)
2725: INTO l_adjustment_limit
2726: FROM je_it_year_ex_limit JIY
2727: WHERE JIY.year = to_char(l_period_date,'RRRR')
2728: AND JIY.month = to_char(l_period_date,'MM')
2729: AND JIY.legal_entity_id = P_LEGAL_ENTITY_ID ;
2730: fnd_file.put_line(fnd_file.log,'Adjustment Amount =>: '||l_adjustment_limit);