DBA Data[Home] [Help]

APPS.HZ_RELATIONSHIP_TYPE_V2PUB dependencies on AR_LOOKUPS

Line 38: FROM ar_lookups

34: )RETURN VARCHAR2
35: IS
36: CURSOR c1 IS
37: SELECT 'Y'
38: FROM ar_lookups
39: WHERE lookup_type = p_lookup_type
40: AND ( lookup_code = p_column_value or
41: meaning = p_meaning )
42: AND rownum = 1;

Line 387: FROM AR_LOOKUPS

383: IF(validate_fnd_lookup('HZ_RELATIONSHIP_TYPE', l_relationship_type, l_relationship_type) = 'N') then
384: /* commented for bug 3831950
385: BEGIN
386: SELECT 1 INTO l_temp_var
387: FROM AR_LOOKUPS
388: WHERE LOOKUP_TYPE = 'HZ_RELATIONSHIP_TYPE'
389: AND LOOKUP_CODE = l_relationship_type;
390:
391: EXCEPTION