APPS.PAY_IN_TAX_UTILS dependencies on PAY_BALANCE_DIMENSIONS

Line 313: , p_dimension_name in pay_balance_dimensions.dimension_name%type)

309: -- --
310: --------------------------------------------------------------------------
311: FUNCTION get_defined_balance
312: (p_balance_type in pay_balance_types.balance_name%type
313: , p_dimension_name in pay_balance_dimensions.dimension_name%type)
314: return number
315: is
316: CURSOR csr_def_bal_id
317: IS

Line 321: ,pay_balance_dimensions pbd

317: IS
318: SELECT pdb.defined_balance_id
319: FROM pay_defined_balances pdb
320: ,pay_balance_types pbt
321: ,pay_balance_dimensions pbd
322: WHERE pbt.balance_name = p_balance_type
323: AND pbd.dimension_name = p_dimension_name
324: AND pdb.balance_type_id = pbt.balance_type_id
325: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

Line 2527: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE

2523: ----------------------------------------------------------------------------
2524: FUNCTION get_balance_value
2525: (p_assignment_action_id IN NUMBER
2526: ,p_balance_name IN pay_balance_types.balance_name%TYPE
2527: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
2528: ,p_context_name IN ff_contexts.context_name%TYPE
2529: ,p_context_value IN VARCHAR2
2530: )
2531: RETURN NUMBER

Line 3314: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE

3310: (p_assignment_id IN NUMBER
3311: ,p_tax_unit_id IN NUMBER
3312: ,p_effective_date IN DATE
3313: ,p_balance_name IN pay_balance_types.balance_name%TYPE
3314: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
3315: ,p_context_name IN ff_contexts.context_name%TYPE
3316: ,p_context_value IN VARCHAR2
3317: ,p_success OUT NOCOPY VARCHAR2
3318: )