DBA Data[Home] [Help]

APPS.PAY_IE_P35 dependencies on PAY_BALANCE_TYPES

Line 636: pay_balance_types pbt,

632: CURSOR csr_defined_balance_id
633: IS
634: SELECT pdb.defined_balance_id
635: FROM pay_balance_dimensions pbd,
636: pay_balance_types pbt,
637: pay_defined_balances pdb
638: WHERE pbd.dimension_name = p_dimension_name
639: AND pbd.business_group_id IS NULL
640: AND pbd.legislation_code = 'IE'

Line 1318: pay_balance_types pbt,

1314: p_balance_name VARCHAR2, --6633719
1315: p_dimension_name VARCHAR2) IS --6633719
1316: SELECT SUBSTR (pai1.action_information4, 1, 30) bval
1317: FROM pay_action_information pai1,
1318: pay_balance_types pbt,
1319: pay_balance_dimensions pbd,
1320: pay_defined_balances pdb
1321: WHERE pdb.balance_type_id = pbt.balance_type_id
1322: AND pbt.legislation_code = 'IE'