APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on DUAL

Line 85: FROM sys.dual

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

Line 175: FROM sys.dual

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

Line 245: FROM sys.dual

241: /*--------------------------------------------------------------------*/
242: BEGIN
243: SELECT 'Y'
244: INTO x_aux
245: FROM sys.dual
246: WHERE EXISTS (
247: SELECT null
248: FROM ce_bank_branches_v
249: WHERE bank_number = e_transferor_bank_code

Line 269: FROM sys.dual;

265: (decode(e_arrears_code,NULL,0,1)*
266: decode(e_arrears_date,NULL,0,1)*
267: nvl(e_arrears_interest,0))
268: INTO x_aux1,x_aux2
269: FROM sys.dual;
270:
271: IF x_aux1 <> 0 AND x_aux2 = 0
272: THEN
273: s_error_code:='13';