DBA Data[Home] [Help]

APPS.HZ_CLASS_VALIDATE_V2PUB dependencies on FND_LOOKUP_VALUES

Line 242: FROM fnd_lookup_values

238: IS
239: CURSOR c1
240: IS
241: SELECT 'Y'
242: FROM fnd_lookup_values
243: WHERE lookup_type = p_lookup_type
244: AND lookup_code = p_column_value
245: -- bug 4212585
246: AND enabled_flag = 'Y'

Line 283: FROM fnd_lookup_values

279: --the period when comparing the lookup_code.
280: CURSOR c_nace
281: IS
282: SELECT 'Y'
283: FROM fnd_lookup_values
284: WHERE lookup_type = p_lookup_type
285: AND replace(lookup_code, '.', '') = replace(p_column_value, '.', '')
286: -- bug 4212585
287: AND enabled_flag = 'Y'

Line 321: from fnd_lookup_values_vl

317: varchar2) return varchar2 is
318:
319: cursor get_invalid_delimiter_csr is
320: select 'x'
321: from fnd_lookup_values_vl
322: where lookup_type = p_class_category
323: and sysdate between start_date_active and nvl(end_date_active,sysdate)
324: and instrb(meaning,p_delimiter)>0;
325:

Line 747: FROM hz_code_assignments ca, fnd_lookup_values_vl lv

743: IS
744: SELECT DISTINCT actual_content_source,
745: owner_table_name,
746: owner_table_id
747: FROM hz_code_assignments ca, fnd_lookup_values_vl lv
748: WHERE ca.class_category = p_class_category
749: AND ca.class_category = lv.lookup_type
750: AND ca.class_code = lv.lookup_code;
751:

Line 1345: FROM fnd_lookup_values

1341: IS
1342: CURSOR cu0
1343: IS
1344: SELECT 'Y'
1345: FROM fnd_lookup_values
1346: WHERE lookup_type = p_class_category
1347: AND lookup_code = p_class_code
1348: AND NVL(end_date_active, p_start_date_active) >= p_start_date_active
1349: AND start_date_active <= p_start_date_active;

Line 3925: * which are difined in FND_LOOKUP_VALUES_U1.

3921: *
3922: * DESCRIPTION
3923: * This procedure is used to check existing record for class category type,
3924: * class coding, security group id, application id, and language combination
3925: * which are difined in FND_LOOKUP_VALUES_U1.
3926: *
3927: * ARGUMENTS
3928: * IN:
3929: * p_class_category_type Related to class category type column

Line 3957: FROM FND_LOOKUP_VALUES

3953:
3954: CURSOR c_exist_class_catgry_type_code(l_class_category_type VARCHAR2, l_class_category_code VARCHAR2, l_security_group_id NUMBER, l_view_application_id NUMBER)
3955: IS
3956: SELECT 'Y'
3957: FROM FND_LOOKUP_VALUES
3958: WHERE LOOKUP_TYPE = l_class_category_type
3959: AND LOOKUP_CODE = l_class_category_code
3960: AND SECURITY_GROUP_ID =l_security_group_id
3961: AND VIEW_APPLICATION_ID = l_view_application_id

Line 3987: * which are difined in FND_LOOKUP_VALUES_U2.

3983: *
3984: * DESCRIPTION
3985: * This procedure is used to check existing record for class category type,
3986: * class meaning, security group id, application id, and language combination
3987: * which are difined in FND_LOOKUP_VALUES_U2.
3988: *
3989: * ARGUMENTS
3990: * IN:
3991: * p_class_category_type Related to class category type column

Line 4020: FROM FND_LOOKUP_VALUES

4016:
4017: CURSOR c_exist_clas_catgry_typ_mng(l_class_category_type VARCHAR2, l_class_category_meaning VARCHAR2, l_security_group_id NUMBER, l_view_application_id NUMBER)
4018: IS
4019: SELECT 'Y'
4020: FROM FND_LOOKUP_VALUES
4021: WHERE LOOKUP_TYPE = l_class_category_type
4022: AND MEANING = l_class_category_meaning
4023: AND SECURITY_GROUP_ID =l_security_group_id
4024: AND VIEW_APPLICATION_ID = l_view_application_id