DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 1969: pay_balance_dimensions pbd,

1965: CURSOR csr_def_bal_id (p_balance_name varchar2
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'

Line 2746: pay_balance_dimensions pbd,

2742: CURSOR csr_def_bal_id (p_balance_name varchar2
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'

Line 3824: ,pay_balance_dimensions pbd

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
3828: AND pbt.legislation_code = 'MX'