APPS.PAY_NO_HOLIDAY_PAY dependencies on FF_GLOBALS_F

Line 15: from ff_globals_f

11: -- l_g_rate := to_number(hruserdt.get_table_value(p_business_group_id, 'NO_GLOBAL_CONSTANTS', 'Value', 'NATIONAL_INSURANCE_BASE_RATE', p_effective_date));
12:
13: select to_number(GLOBAL_VALUE)
14: into l_g_rate
15: from ff_globals_f
16: where global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
17: and LEGISLATION_CODE = 'NO'
18: and BUSINESS_GROUP_ID IS NULL
19: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE ;

Line 137: FROM ff_globals_f fgf

133: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
134:
135: CURSOR csr_globals(p_global_name VARCHAR2) IS
136: SELECT fgf.global_value
137: FROM ff_globals_f fgf
138: WHERE fgf.global_name = p_global_name
139: AND fgf.legislation_code = 'NO'
140: AND p_effective_date BETWEEN fgf.effective_start_date
141: AND fgf.effective_end_date;

Line 150: l_global_name ff_globals_f.global_name%TYPE;

146: l_entit_days_over_60 NUMBER;
147: l_assig_details csr_assig_details % rowtype;
148: l_person_details csr_person_details % rowtype;
149: l_le_details csr_le_details % rowtype;
150: l_global_name ff_globals_f.global_name%TYPE;
151: BEGIN
152:
153: /*Bug 5346834 fix*/
154: