DBA Data[Home] [Help]

APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on FND_LOOKUPS

Line 88: FROM FND_LOOKUPS

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

Line 137: FROM fnd_lookups

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