APPS.CREATE_GB_RTI_EPS_RECORD dependencies on FF_GLOBALS_F

Line 55: FROM FF_GLOBALS_F

51: IS
52: SELECT MAX(DECODE(GLOBAL_NAME,P_GLOBAL_NAME1,GLOBAL_VALUE,NULL)) L_SMP_SAP_RATE,
53: MAX(DECODE(GLOBAL_NAME,p_global_name2,GLOBAL_VALUE,NULL)) l_ssp_rate,
54: MAX(DECODE(GLOBAL_NAME,p_global_name3,GLOBAL_VALUE,NULL)) l_nic_rate
55: FROM FF_GLOBALS_F
56: WHERE GLOBAL_NAME IN (p_global_name1, p_global_name2,p_global_name3)
57: AND L_EFF_START_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
58:
59: -- get the defined balance id for specified balance and dimension

Line 484: select global_value into l_rec_rate from ff_globals_f where global_name = 'SMP_RECOVERY_PERCENTAGE' and legislation_code = 'GB' and

480: open get_smp_org_value;
481: fetch get_smp_org_value into g_smp_recovery;
482: close get_smp_org_value;
483:
484: select global_value into l_rec_rate from ff_globals_f where global_name = 'SMP_RECOVERY_PERCENTAGE' and legislation_code = 'GB' and
485: l_eff_date between effective_start_date and effective_end_date;
486:
487: select global_value into l_nic_rate from ff_globals_f where global_name = 'NIC_COMPENSATION_RATE_ON_SMP' and legislation_code = 'GB' and
488: l_eff_date between effective_start_date and effective_end_date;

Line 487: select global_value into l_nic_rate from ff_globals_f where global_name = 'NIC_COMPENSATION_RATE_ON_SMP' and legislation_code = 'GB' and

483:
484: select global_value into l_rec_rate from ff_globals_f where global_name = 'SMP_RECOVERY_PERCENTAGE' and legislation_code = 'GB' and
485: l_eff_date between effective_start_date and effective_end_date;
486:
487: select global_value into l_nic_rate from ff_globals_f where global_name = 'NIC_COMPENSATION_RATE_ON_SMP' and legislation_code = 'GB' and
488: l_eff_date between effective_start_date and effective_end_date;
489:
490:
491: fnd_file.put_line(fnd_file.LOG,'Entering in get_rec_and_nic. l_rec_rate: ' || l_rec_rate);