APPS.PAY_NL_GENERAL dependencies on FF_GLOBALS_F

Line 698: from ff_globals_f

694:
695:
696: ,l_date_earned date) IS
697: select GLOBAL_VALUE
698: from ff_globals_f
699: where global_name = l_global_name
700: and LEGISLATION_CODE = 'NL'
701: and BUSINESS_GROUP_ID IS NULL
702: and l_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 704: l_value ff_globals_f.global_value%TYPE;

700: and LEGISLATION_CODE = 'NL'
701: and BUSINESS_GROUP_ID IS NULL
702: and l_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
703:
704: l_value ff_globals_f.global_value%TYPE;
705: Begin
706:
707: OPEN get_global_value(l_global_name,l_date_earned);
708: FETCH get_global_value INTO l_value;

Line 723: from ff_globals_f

719:
720: cursor get_global_value(l_global_name varchar2
721: ,l_date date) IS
722: select GLOBAL_VALUE
723: from ff_globals_f
724: where global_name = l_global_name
725: and LEGISLATION_CODE = 'NL'
726: and BUSINESS_GROUP_ID IS NULL
727: and l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 729: l_value ff_globals_f.global_value%TYPE;

725: and LEGISLATION_CODE = 'NL'
726: and BUSINESS_GROUP_ID IS NULL
727: and l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
728:
729: l_value ff_globals_f.global_value%TYPE;
730:
731: l_date date;
732: l_effective_date_ppa date;
733: l_date_earned_ppa date;