APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_DEFINED_BALANCES

Line 1774: ln_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

1770: ln_payroll_id NUMBER;
1771:
1772: ln_isr_withheld NUMBER;
1773: l_credit_to_salary_table varchar2(100) := P_CREDIT_TO_SALARY_TABLE;
1774: ln_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
1775: ln_bal_amt NUMBER;
1776: ln_bal_sub NUMBER;
1777: ln_bal_sub_paid NUMBER;
1778: ln_isr_subject_mtd NUMBER;

Line 1827: FROM pay_defined_balances pdb,

1823:
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

Line 2527: ,pay_defined_balances pdb

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'
2531: AND pbd.legislation_code = 'MX'