DBA Data[Home] [Help]

APPS.PAY_AU_REC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    select nvl(hr_aubal.calc_asg_run(c_assignment_action_id,
                                     balance_type_id,
                                     c_effective_date,
                                     c_assignment_id),0)
    from   pay_balance_types
    where  balance_name = c_balance_name
    and    legislation_code = 'AU';