372: l_element_entry_id NUMBER;
373: l_element_name pay_element_types_f.element_name %TYPE;
374: l_ppf_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;
375: l_ppf_amount pay_element_entry_values_f.screen_entry_value%TYPE;
376: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;
377:
378: CURSOR c_element_name IS
379: SELECT pet.ELEMENT_NAME
380: FROM pay_element_types_f pet
409:
410: CURSOR get_ppf_max_exemption_limit
411: IS
412: SELECT global_value
413: FROM ff_globals_f ffgf
414: WHERE global_name = 'IN_PPF_MAX_EXEMPTION_LIMIT_80C'
415: AND legislation_code = 'IN'
416: AND p_effective_date between ffgf.effective_start_date and ffgf.effective_end_date;
417:
515: l_element_entry_id NUMBER;
516: l_element_name pay_element_types_f.element_name %TYPE;
517: l_ppf_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;
518: l_ppf_amount pay_element_entry_values_f.screen_entry_value%TYPE;
519: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;
520:
521: CURSOR c_element_name IS
522: SELECT pet.ELEMENT_NAME
523: FROM pay_element_types_f pet
551:
552: CURSOR get_ppf_max_exemption_limit
553: IS
554: SELECT global_value
555: FROM ff_globals_f ffgf
556: WHERE ffgf.global_name = 'IN_PPF_MAX_EXEMPTION_LIMIT_80C'
557: AND ffgf.legislation_code = 'IN'
558: AND p_effective_date between ffgf.effective_start_date and ffgf.effective_end_date;
559: