DBA Data[Home] [Help]

APPS.PAY_CN_BAL_UPL_STRUCT dependencies on PAY_BALANCE_BATCH_HEADERS

Line 374: pay_balance_batch_headers bbh

370: CURSOR csr_bg IS
371: SELECT hou.business_group_id,
372: hou.legislation_code
373: FROM per_business_groups hou,
374: pay_balance_batch_headers bbh
375: WHERE bbh.batch_id = p_batch_id
376: AND upper(hou.name) = upper(bbh.business_group_name);
377: --
378: CURSOR c_each_batch (c_batch_id NUMBER) IS

Line 520: FROM pay_balance_batch_headers bbh

516: SELECT pbg.business_group_id
517: ,bbh.business_group_name
518: ,pbg.currency_code
519: ,pbg.legislation_code
520: FROM pay_balance_batch_headers bbh
521: ,per_business_groups pbg
522: WHERE batch_id = p_batch_id
523: AND upper(pbg.name) = upper(bbh.business_group_name);
524: