APPS.PAY_IE_P35 dependencies on PAY_BALANCE_DIMENSIONS

Line 642: FROM pay_balance_dimensions pbd,

638: AS
639: CURSOR csr_defined_balance_id
640: IS
641: SELECT pdb.defined_balance_id
642: FROM pay_balance_dimensions pbd,
643: pay_balance_types pbt,
644: pay_defined_balances pdb
645: WHERE pbd.dimension_name = p_dimension_name
646: AND pbd.business_group_id IS NULL

Line 1624: pay_balance_dimensions pbd,

1620: p_dimension_name VARCHAR2) IS --6633719
1621: SELECT SUBSTR (pai1.action_information4, 1, 30) bval
1622: FROM pay_action_information pai1,
1623: pay_balance_types pbt,
1624: pay_balance_dimensions pbd,
1625: pay_defined_balances pdb
1626: WHERE pdb.balance_type_id = pbt.balance_type_id
1627: AND pbt.legislation_code = 'IE'
1628: AND UPPER (pbt.balance_name) = p_balance_name