APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on FF_GLOBALS_F

Line 2814: FROM ff_globals_f

2810: --------Cursor ---to get the ceiling value-------
2811: CURSOR c_esi_ceiling_value(c_global_value VARCHAR2)
2812: IS
2813: SELECT global_value
2814: FROM ff_globals_f
2815: WHERE legislation_code='IN'
2816: AND global_name = c_global_value
2817: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
2818:

Line 2865: l_global_value ff_globals_f.global_name%TYPE;

2861: l_esi_con_salary NUMBER ;
2862: l_hire_date DATE;
2863: l_disable_proof VARCHAR2(10);
2864: l_emplr_class hr_organization_information.org_information3%TYPE;
2865: l_global_value ff_globals_f.global_name%TYPE;
2866: l_dummy NUMBER;
2867:
2868: l_message VARCHAR2(255);
2869: l_procedure VARCHAR2(100);