DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_BALANCE_TYPES

Line 1535: FROM pay_balance_types pbt

1531:
1532:
1533: CURSOR csr_balance_type_id(p_balance_name IN VARCHAR2) IS
1534: SELECT balance_type_id
1535: FROM pay_balance_types pbt
1536: WHERE pbt.balance_name = p_balance_name
1537: AND legislation_code ='IN';
1538:
1539:

Line 1638: ,pay_balance_types pbt

1634: p_dimension_name VARCHAR2)
1635: IS
1636: SELECT pdb.defined_balance_id
1637: FROM pay_defined_balances pdb
1638: ,pay_balance_types pbt
1639: ,pay_balance_dimensions pbd
1640: WHERE pbt.balance_name = p_balance_name
1641: AND pbd.dimension_name = p_dimension_name
1642: AND pdb.balance_type_id = pbt.balance_type_id