DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 285: from pay_balance_dimensions

281: and legislation_code = 'FR';
282: --
283: cursor csr_get_dimension (p_name varchar2) is
284: select balance_dimension_id
285: from pay_balance_dimensions
286: where legislation_code = 'FR'
287: and dimension_name = p_name;
288: --
289: cursor csr_get_per_id is

Line 3281: ,pay_balance_dimensions d

3277: SELECT defined_balance_id
3278: INTO l_defined_balance_id
3279: FROM pay_defined_balances db
3280: ,pay_balance_types b
3281: ,pay_balance_dimensions d
3282: WHERE b.balance_name = p_balance_name
3283: AND d.dimension_name = p_dimension
3284: AND db.balance_type_id = b.balance_type_id
3285: AND db.balance_dimension_id = d.balance_dimension_id