APPS.PAY_CN_DEDUCTIONS dependencies on PAY_DEFINED_BALANCES

Line 2385: FROM pay_defined_balances pdb

2381:
2382: CURSOR csr_def_bal_id
2383: IS
2384: SELECT pdb.defined_balance_id
2385: FROM pay_defined_balances pdb
2386: ,pay_balance_types pbt
2387: ,pay_balance_dimensions pbd
2388: WHERE pbt.balance_name = p_balance_name
2389: AND pbd.dimension_name = p_dimension_name

Line 2396: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

2392: AND pbd.legislation_code = 'CN'
2393: AND pdb.legislation_code = 'CN'
2394: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
2395:
2396: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2397: l_message VARCHAR2(80);
2398:
2399: BEGIN
2400: l_message := 'SUCCESS';