DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on FF_GLOBALS_F

Line 2602: FROM ff_globals_f

2598: --------Cursor ---to get the ceiling value-------
2599: CURSOR c_esi_ceiling_value(c_global_value VARCHAR2)
2600: IS
2601: SELECT global_value
2602: FROM ff_globals_f
2603: WHERE legislation_code='IN'
2604: AND global_name = c_global_value
2605: AND p_payroll_date BETWEEN effective_start_date AND effective_end_date;
2606:

Line 2653: l_global_value ff_globals_f.global_name%TYPE;

2649: l_esi_con_salary NUMBER ;
2650: l_hire_date DATE;
2651: l_disable_proof VARCHAR2(10);
2652: l_emplr_class hr_organization_information.org_information3%TYPE;
2653: l_global_value ff_globals_f.global_name%TYPE;
2654: l_dummy NUMBER;
2655:
2656: l_message VARCHAR2(255);
2657: l_procedure VARCHAR2(100);