DBA Data[Home] [Help]

APPS.PER_IN_ENTRY_VALUE_LEG_HOOK dependencies on FF_GLOBALS_F

Line 376: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;

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

Line 413: FROM ff_globals_f ffgf

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:

Line 519: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;

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

Line 555: FROM ff_globals_f ffgf

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: