DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 2389: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE)

2385: --1.1 13-Mar-13 mdubasi Handled no-data found --
2386: ----------------------------------------------------------------------------
2387: FUNCTION get_def_bal_id
2388: (p_balance_name IN pay_balance_types.balance_name%TYPE
2389: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE)
2390: RETURN NUMBER
2391: IS
2392:
2393: CURSOR csr_def_bal_id

Line 2398: ,pay_balance_dimensions pbd

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
2401: AND pdb.balance_type_id = pbt.balance_type_id
2402: AND pbt.legislation_code = 'CN'