DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on FND_GLOBAL

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

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

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

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

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

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

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

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