APPS.PAY_CN_DEDUCTIONS dependencies on PAY_DEFINED_BALANCES

Line 2396: FROM pay_defined_balances pdb

2392:
2393: CURSOR csr_def_bal_id
2394: IS
2395: SELECT pdb.defined_balance_id
2396: FROM pay_defined_balances pdb
2397: ,pay_balance_types pbt
2398: ,pay_balance_dimensions pbd
2399: WHERE pbt.balance_name = p_balance_name
2400: AND pbd.dimension_name = p_dimension_name

Line 2407: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

2403: AND pbd.legislation_code = 'CN'
2404: AND pdb.legislation_code = 'CN'
2405: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
2406:
2407: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2408: l_message VARCHAR2(80);
2409:
2410: BEGIN
2411: l_message := 'SUCCESS';