DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_BALANCE_TYPES

Line 1829: pay_balance_types pbt

1825: ,p_db_item_suffix varchar2) IS
1826: SELECT pdb.defined_balance_id
1827: FROM pay_defined_balances pdb,
1828: pay_balance_dimensions pbd,
1829: pay_balance_types pbt
1830: WHERE pbd.balance_dimension_id = pdb.balance_dimension_id
1831: AND pbt.balance_type_id = pdb.balance_type_id
1832: AND pbd.database_item_suffix = p_db_item_suffix -- '_ASG_GRE_MTD'
1833: AND pbt.balance_name = p_balance_name; --'ISR Subsidy for Employment'

Line 2525: FROM pay_balance_types pbt

2521: CURSOR c_defined_balance_id(p_balance_name VARCHAR2
2522: ,p_dimension VARCHAR2)
2523: IS
2524: SELECT pdb.defined_balance_id
2525: FROM pay_balance_types pbt
2526: ,pay_balance_dimensions pbd
2527: ,pay_defined_balances pdb
2528: WHERE pbt.balance_name=p_balance_name
2529: AND pbd.database_item_suffix =p_dimension