DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_BALANCE_TYPES

Line 1592: FROM pay_balance_types pbt

1588:
1589:
1590: CURSOR csr_balance_type_id(p_balance_name IN VARCHAR2) IS
1591: SELECT balance_type_id
1592: FROM pay_balance_types pbt
1593: WHERE pbt.balance_name = p_balance_name
1594: AND legislation_code ='IN';
1595:
1596:

Line 1695: ,pay_balance_types pbt

1691: p_dimension_name VARCHAR2)
1692: IS
1693: SELECT pdb.defined_balance_id
1694: FROM pay_defined_balances pdb
1695: ,pay_balance_types pbt
1696: ,pay_balance_dimensions pbd
1697: WHERE pbt.balance_name = p_balance_name
1698: AND pbd.dimension_name = p_dimension_name
1699: AND pdb.balance_type_id = pbt.balance_type_id