DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 1828: pay_balance_dimensions pbd,

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

Line 2526: ,pay_balance_dimensions pbd

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