DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PAY_BALANCE_TYPES

Line 3280: ,pay_balance_types b

3276: hr_utility.set_location('Entering ' || l_proc, 10);
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

Line 3451: , pay_balance_types b

3447: , max(aa.assignment_action_id) assignment_action_id
3448: , nvl(fcu.group_code, pet.element_information1) element_group
3449: from pay_action_interlocks arclck
3450: , pay_action_interlocks prelck
3451: , pay_balance_types b
3452: , pay_run_balances rb
3453: , pay_defined_balances db
3454: , pay_payroll_actions pa
3455: , pay_assignment_actions aa