APPS.PAY_IN_TAX_UTILS dependencies on PAY_BALANCE_DIMENSIONS

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

437: -- --
438: --------------------------------------------------------------------------
439: FUNCTION get_defined_balance
440: (p_balance_type in pay_balance_types.balance_name%type
441: , p_dimension_name in pay_balance_dimensions.dimension_name%type)
442: return number
443: is
444: CURSOR csr_def_bal_id
445: IS

Line 449: ,pay_balance_dimensions pbd

445: IS
446: SELECT pdb.defined_balance_id
447: FROM pay_defined_balances pdb
448: ,pay_balance_types pbt
449: ,pay_balance_dimensions pbd
450: WHERE pbt.balance_name = p_balance_type
451: AND pbd.dimension_name = p_dimension_name
452: AND pdb.balance_type_id = pbt.balance_type_id
453: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

Line 2963: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE

2959: ----------------------------------------------------------------------------
2960: FUNCTION get_balance_value
2961: (p_assignment_action_id IN NUMBER
2962: ,p_balance_name IN pay_balance_types.balance_name%TYPE
2963: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
2964: ,p_context_name IN ff_contexts.context_name%TYPE
2965: ,p_context_value IN VARCHAR2
2966: )
2967: RETURN NUMBER

Line 4367: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE

4363: (p_assignment_id IN NUMBER
4364: ,p_tax_unit_id IN NUMBER
4365: ,p_effective_date IN DATE
4366: ,p_balance_name IN pay_balance_types.balance_name%TYPE
4367: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
4368: ,p_context_name IN ff_contexts.context_name%TYPE
4369: ,p_context_value IN VARCHAR2
4370: ,p_success OUT NOCOPY VARCHAR2
4371: )