DBA Data[Home] [Help]

APPS.PAY_IP_BAL_UPL_STRUCT dependencies on PAY_BALANCE_BATCH_HEADERS

Line 248: pay_balance_batch_headers bbh

244: hou.legislation_code
245: into l_bg_id,
246: l_leg_code
247: from per_business_groups hou,
248: pay_balance_batch_headers bbh
249: where bbh.batch_id = p_batch_id
250: and upper(hou.name) = upper(bbh.business_group_name);
251: EXCEPTION WHEN no_data_found THEN
252: local_error(retcode, 'validate_batch_data', 3);

Line 327: from pay_balance_batch_headers bbh,

323: select pbg.business_group_id, bbh.business_group_name ,
324: pbg.currency_code, pbg.legislation_code
325: into l_bg_id, l_bg_name,
326: l_currency_code, l_leg_code
327: from pay_balance_batch_headers bbh,
328: per_business_groups pbg
329: where batch_id = p_batch_id
330: and upper(pbg.name) = upper(bbh.business_group_name);
331: