APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_DEFINED_BALANCES

Line 1908: ln_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

1904: ln_payroll_id NUMBER;
1905:
1906: ln_isr_withheld NUMBER;
1907: l_credit_to_salary_table varchar2(100) := P_CREDIT_TO_SALARY_TABLE;
1908: ln_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
1909: ln_bal_amt NUMBER;
1910: ln_bal_sub NUMBER;
1911: ln_bal_sub_paid NUMBER;
1912: ln_isr_subject_mtd NUMBER;

Line 1968: FROM pay_defined_balances pdb,

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

Line 2657: ln_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

2653: ln_payroll_id NUMBER;
2654:
2655: ln_isr_withheld NUMBER;
2656: l_credit_to_salary_table varchar2(100) := P_CREDIT_TO_SALARY_TABLE;
2657: ln_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2658: ln_bal_amt NUMBER;
2659: ln_bal_sub NUMBER;
2660: ln_bal_sub_paid NUMBER;
2661: tot_subsidy_empl NUMBER;

Line 2745: FROM pay_defined_balances pdb,

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

Line 3825: ,pay_defined_balances pdb

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