DBA Data[Home] [Help]

APPS.HZ_COPY_REL_PVT dependencies on AR_LOOKUPS

Line 79: FROM ar_lookups

75: IS
76: CURSOR c0
77: IS
78: SELECT meaning
79: FROM ar_lookups
80: WHERE lookup_code = p_lookup_code
81: and lookup_type = 'HZ_RELATIONSHIP_ROLE'
82: and rownum = 1 ;
83: meaning VARCHAR2(200);

Line 104: FROM ar_lookups

100: IS
101: CURSOR c0
102: IS
103: SELECT description
104: FROM ar_lookups
105: WHERE lookup_code = p_lookup_code
106: and lookup_type = 'HZ_RELATIONSHIP_ROLE'
107: and rownum = 1 ;
108: description VARCHAR2(200);

Line 1763: FROM ar_lookups

1759: -- prepare output file
1760: --
1761: SELECT meaning
1762: INTO l_meaning
1763: FROM ar_lookups
1764: WHERE lookup_type = 'HZ_RELATIONSHIP_TYPE'
1765: AND lookup_code = p_rel_type;
1766:
1767: FND_MESSAGE.SET_NAME('AR', 'HZ_CIRCULAR_REL_EXIST_FMT1');