DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on FF_GLOBALS_F

Line 2371: CURSOR csr_global_value(p_global_name ff_globals_f.global_name%TYPE)

2367: AND paa.payroll_action_id = ppa.payroll_action_id
2368: AND ppa.business_group_id = p_business_group_id );
2369:
2370:
2371: CURSOR csr_global_value(p_global_name ff_globals_f.global_name%TYPE)
2372: IS
2373: SELECT global_value
2374: FROM ff_globals_f
2375: WHERE global_name =p_global_name

Line 2374: FROM ff_globals_f

2370:
2371: CURSOR csr_global_value(p_global_name ff_globals_f.global_name%TYPE)
2372: IS
2373: SELECT global_value
2374: FROM ff_globals_f
2375: WHERE global_name =p_global_name
2376: AND legislation_code='IN'
2377: AND g_tax_end_date BETWEEN effective_start_date and effective_end_date;
2378:

Line 2629: CURSOR csr_global_value(p_global_name ff_globals_f.global_name%TYPE)

2625: AND paa.payroll_action_id = ppa.payroll_action_id
2626: AND ppa.business_group_id = p_business_group_id );
2627:
2628:
2629: CURSOR csr_global_value(p_global_name ff_globals_f.global_name%TYPE)
2630: IS
2631: SELECT global_value
2632: FROM ff_globals_f
2633: WHERE global_name =p_global_name

Line 2632: FROM ff_globals_f

2628:
2629: CURSOR csr_global_value(p_global_name ff_globals_f.global_name%TYPE)
2630: IS
2631: SELECT global_value
2632: FROM ff_globals_f
2633: WHERE global_name =p_global_name
2634: AND legislation_code='IN'
2635: AND g_tax_end_date BETWEEN effective_start_date and effective_end_date;
2636: