DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_BALANCE_TYPES

Line 1970: pay_balance_types pbt

1966: ,p_db_item_suffix varchar2) IS
1967: SELECT pdb.defined_balance_id
1968: FROM pay_defined_balances pdb,
1969: pay_balance_dimensions pbd,
1970: pay_balance_types pbt
1971: WHERE pbd.balance_dimension_id = pdb.balance_dimension_id
1972: AND pbt.balance_type_id = pdb.balance_type_id
1973: AND pbd.database_item_suffix = p_db_item_suffix -- '_ASG_GRE_MTD'
1974: AND pbt.balance_name = p_balance_name; --'ISR Subsidy for Employment'

Line 2747: pay_balance_types pbt

2743: ,p_db_item_suffix varchar2) IS
2744: SELECT pdb.defined_balance_id
2745: FROM pay_defined_balances pdb,
2746: pay_balance_dimensions pbd,
2747: pay_balance_types pbt
2748: WHERE pbd.balance_dimension_id = pdb.balance_dimension_id
2749: AND pbt.balance_type_id = pdb.balance_type_id
2750: AND pbd.database_item_suffix = p_db_item_suffix -- '_ASG_GRE_MTD'
2751: AND pbt.balance_name = p_balance_name; --'ISR Subsidy for Employment'

Line 3823: FROM pay_balance_types pbt

3819: CURSOR c_defined_balance_id(p_balance_name VARCHAR2
3820: ,p_dimension VARCHAR2)
3821: IS
3822: SELECT pdb.defined_balance_id
3823: FROM pay_balance_types pbt
3824: ,pay_balance_dimensions pbd
3825: ,pay_defined_balances pdb
3826: WHERE pbt.balance_name=p_balance_name
3827: AND pbd.database_item_suffix =p_dimension