APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on DUAL

Line 87: FROM sys.dual

83: /*--------------------------------------------------------------------*/
84: BEGIN
85: SELECT 'Y'
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'

Line 178: FROM sys.dual

174:
175: BEGIN
176: SELECT 'Y'
177: INTO x_aux
178: FROM sys.dual
179: WHERE EXISTS (
180: SELECT null
181: FROM ce_bank_accounts
182: WHERE bank_branch_id = x_bank_branch_id

Line 254: FROM sys.dual

250: /*--------------------------------------------------------------------*/
251: BEGIN
252: SELECT 'Y'
253: INTO x_aux
254: FROM sys.dual
255: WHERE EXISTS (
256: SELECT null
257: FROM ce_bank_branches_v
258: WHERE bank_number = e_transferor_bank_code

Line 278: FROM sys.dual;

274: (decode(e_arrears_code,NULL,0,1)*
275: decode(e_arrears_date,NULL,0,1)*
276: nvl(e_arrears_interest,0))
277: INTO x_aux1,x_aux2
278: FROM sys.dual;
279:
280: IF x_aux1 <> 0 AND x_aux2 = 0
281: THEN
282: s_error_code:='13';