APPS.PAY_IN_REPORTS_PKG dependencies on FF_GLOBALS_F

Line 1567: FROM ff_globals_f where global_name = 'IN_EPS_AGE';

1563: pay_in_utils.trace('l_month : ',l_mon);
1564: END IF;
1565:
1566: SELECT TO_NUMBER(GLOBAL_VALUE) INTO l_eps_age
1567: FROM ff_globals_f where global_name = 'IN_EPS_AGE';
1568:
1569:
1570:
1571: IF g_debug THEN

Line 2122: FROM ff_globals_f glb

2118:
2119: /*Find the global value as on Financial year start */
2120: CURSOR csr_global_value(p_name VARCHAR2) IS
2121: SELECT fnd_number.canonical_to_number(glb.global_value)
2122: FROM ff_globals_f glb
2123: WHERE glb.global_name = p_name
2124: AND glb.LEGISLATION_CODE ='IN'
2125: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;
2126:

Line 3412: FROM FF_GLOBALS_F

3408: END IF;
3409:
3410: --Statuory Rate of Contribution
3411: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
3412: FROM FF_GLOBALS_F
3413: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
3414: AND LEGISLATION_CODE='IN'
3415: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;
3416:

Line 4291: FROM FF_GLOBALS_F

4287: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4289: --Statuory Rate of Contribution
4290: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
4291: FROM FF_GLOBALS_F
4292: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
4293: AND LEGISLATION_CODE='IN'
4294: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;
4295:

Line 4485: FROM ff_globals_f glb

4481:
4482: /*Find the global value as on Financial year start */
4483: CURSOR csr_global_value(p_name VARCHAR2) IS
4484: SELECT fnd_number.canonical_to_number(glb.global_value)
4485: FROM ff_globals_f glb
4486: WHERE glb.global_name = p_name
4487: AND glb.LEGISLATION_CODE ='IN'
4488: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;
4489: