DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD_13 dependencies on FF_GLOBALS_F

Line 64: FROM FF_GLOBALS_F

60: IS
61: SELECT MAX(DECODE(GLOBAL_NAME,P_GLOBAL_NAME1,GLOBAL_VALUE,NULL)) L_SMP_SAP_RATE,
62: MAX(DECODE(GLOBAL_NAME,p_global_name2,GLOBAL_VALUE,NULL)) l_ssp_rate,
63: MAX(DECODE(GLOBAL_NAME,p_global_name3,GLOBAL_VALUE,NULL)) l_nic_rate
64: FROM FF_GLOBALS_F
65: WHERE GLOBAL_NAME IN (p_global_name1, p_global_name2,p_global_name3)
66: AND L_EFF_START_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
67:
68: -- get the defined balance id for specified balance and dimension