APPS.HR_GENERATE_PRETAX dependencies on PAY_BALANCE_CLASSIFICATIONS

Line 383: pay_balance_classifications bc

379: bc.CLASSIFICATION_ID, pbf.BUSINESS_GROUP_ID,
380: pbf.LEGISLATION_CODE, pbf.BALANCE_TYPE_ID,
381: pbf.INPUT_VALUE_ID, pbf.SCALE, pbf.ELEMENT_TYPE_ID
382: FROM PAY_BALANCE_FEEDS_V pbf,
383: pay_balance_classifications bc
384: WHERE NVL(pbf.BALANCE_INITIALIZATION_FLAG,'N') = 'N'
385: AND ((pbf.BUSINESS_GROUP_ID IS NULL OR pbf.BUSINESS_GROUP_ID = p_bg_id)
386: AND (pbf.LEGISLATION_CODE IS NULL OR pbf.LEGISLATION_CODE = 'US'))
387: and (pbf.BALANCE_NAME = 'Regular Earnings')

Line 3576: FROM pay_balance_classifications pbc,

3572: already_exists number;
3573:
3574: CURSOR get_pretax_bals IS
3575: SELECT pbc.balance_type_id
3576: FROM pay_balance_classifications pbc,
3577: pay_element_classifications pec,
3578: pay_balance_types pbt
3579: WHERE nvl(pbc.business_group_id, p_busgrp_id) = p_busgrp_id
3580: AND nvl(pbc.legislation_code, 'US') = 'US'