DBA Data[Home] [Help]

APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on FND_LOOKUPS

Line 90: FROM FND_LOOKUPS

86: INTO x_aux
87: FROM sys.dual
88: WHERE EXISTS (
89: SELECT null
90: FROM FND_LOOKUPS
91: WHERE lookup_type = 'JLBR_ARREARS_CODE'
92: AND lookup_code = e_arrears_code );
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN

Line 140: FROM fnd_lookups

136:
137: BEGIN
138: SELECT '1'
139: INTO x_register_type
140: FROM fnd_lookups
141: WHERE lookup_code = e_drawee_inscription_type
142: AND lookup_type = 'JLBR_INSCRIPTION_TYPE'
143: AND NVL(end_date_active,sysdate + 1) > sysdate;
144: EXCEPTION