APPS.PAY_IN_REPORTS_PKG dependencies on FF_GLOBALS_F

Line 1541: FROM ff_globals_f glb

1537:
1538: /*Find the global value as on Financial year start */
1539: CURSOR csr_global_value(p_name VARCHAR2) IS
1540: SELECT fnd_number.canonical_to_number(glb.global_value)
1541: FROM ff_globals_f glb
1542: WHERE glb.global_name = p_name
1543: AND glb.LEGISLATION_CODE ='IN'
1544: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;
1545:

Line 2822: FROM FF_GLOBALS_F

2818: END IF;
2819:
2820: --Statuory Rate of Contribution
2821: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
2822: FROM FF_GLOBALS_F
2823: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
2824: AND LEGISLATION_CODE='IN'
2825: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;
2826:

Line 3575: FROM FF_GLOBALS_F

3571: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
3572: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3573: --Statuory Rate of Contribution
3574: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
3575: FROM FF_GLOBALS_F
3576: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'
3577: AND LEGISLATION_CODE='IN'
3578: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;
3579:

Line 3766: FROM ff_globals_f glb

3762:
3763: /*Find the global value as on Financial year start */
3764: CURSOR csr_global_value(p_name VARCHAR2) IS
3765: SELECT fnd_number.canonical_to_number(glb.global_value)
3766: FROM ff_globals_f glb
3767: WHERE glb.global_name = p_name
3768: AND glb.LEGISLATION_CODE ='IN'
3769: AND p_effective_end_date BETWEEN glb.effective_start_date and glb.effective_end_date;
3770: