DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on FND_GLOBAL

Line 195: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)

191: WHERE
192: flv.lookup_type = p_lookup_type
193: AND flv.view_application_id = p_view_app_id
194: AND flv.lookup_code = p_lookup_code
195: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
196: AND flv.LANGUAGE = USERENV('LANG')
197: AND flv.enabled_flag = 'Y'
198: AND TRUNC(NVL(flv.start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
199: AND TRUNC(NVL(flv.end_date_active, l_sysdate)) >= TRUNC(l_sysdate)

Line 1068: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)

1064: WHERE
1065: flv.lookup_type = p_lookup_type
1066: AND flv.view_application_id = p_view_app_id
1067: AND flv.lookup_code = p_lookup_code
1068: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
1069: AND flv.LANGUAGE = USERENV('LANG')
1070: AND flv.enabled_flag = 'Y'
1071: AND TRUNC(NVL(flv.start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1072: AND TRUNC(NVL(flv.end_date_active, l_sysdate)) >= TRUNC(l_sysdate)

Line 1112: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)

1108: WHERE
1109: flv.lookup_type = p_lookup_type
1110: AND flv.view_application_id = p_view_app_id
1111: AND flv.lookup_code = p_lookup_code
1112: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
1113: AND flv.LANGUAGE = p_language
1114: AND flv.enabled_flag = 'Y'
1115: AND TRUNC(NVL(flv.start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1116: AND TRUNC(NVL(flv.end_date_active, l_sysdate)) >= TRUNC(l_sysdate)

Line 1782: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)

1778: WHERE flv.lookup_type = flt.lookup_type
1779: AND flv.security_group_id = flt.security_group_id
1780: AND flv.view_application_id = flt.view_application_id
1781: AND flv.LANGUAGE = USERENV('LANG')
1782: AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
1783: AND flt.lookup_type = 'OKC_RULE_DEF'
1784: AND flv.lookup_code = c_rule_code
1785: AND flt.application_id = 510
1786: AND flv.view_application_id = 0