DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_DEFINED_BALANCES

Line 2759: pay_defined_balances pdb

2755: CURSOR get_sui_taxable_def_bal_id IS
2756: SELECT pdb.defined_balance_id
2757: FROM pay_balance_types pbt,
2758: pay_balance_dimensions pbd,
2759: pay_defined_balances pdb
2760: WHERE pbt.balance_name in ('SUI ER Taxable','SUI EE Taxable')
2761: AND pbt.balance_type_id=pdb.balance_type_id
2762: AND pbd.dimension_name = 'Person within Government Reporting Entity Year to Date'
2763: AND pbd.balance_dimension_id=pdb.balance_dimension_id

Line 2838: l_sui_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

2834: /*Added for Bug#9075526*/
2835: l_sui_auto_credit VARCHAR2(2) := 'N'; /*Added for Bug#9075526*/
2836: l_run_route VARCHAR2(5);
2837: l_run_route_bool BOOLEAN;
2838: l_sui_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2839: l_end_of_year_date DATE ;
2840: /*End Bug#9075526*/
2841:
2842: /*Added for Bug#9872952*/

Line 3109: pay_defined_balances db

3105: select defined_balance_id
3106: into l_ss_er_w11_def_bal_id
3107: from pay_balance_types bt,
3108: pay_balance_dimensions bd,
3109: pay_defined_balances db
3110: where bt.balance_name = 'SS ER W11 Taxable'
3111: and bd.dimension_name = 'Person within Government Reporting Entity Year to Date'
3112: and bd.legislation_code = 'US'
3113: and db.balance_type_id = bt.balance_type_id