944: FROM SYS.DUAL
945: WHERE EXISTS (SELECT 'X'
946: FROM pay_payroll_actions pya,
947: pay_assignment_actions asa,
948: pay_assignment_latest_balances alb
949: WHERE alb.assignment_id = p_asg_id
950: AND alb.defined_balance_id = p_def_bal_id
951: AND alb.assignment_action_id = asa.assignment_action_id
952: AND asa.payroll_action_id = pya.payroll_action_id
1487: FROM SYS.DUAL
1488: WHERE EXISTS (SELECT 'X'
1489: FROM pay_payroll_actions pya,
1490: pay_assignment_actions asa,
1491: pay_assignment_latest_balances alb
1492: WHERE alb.assignment_id = p_asg_id
1493: AND alb.defined_balance_id = p_def_bal_id
1494: AND alb.assignment_action_id = asa.assignment_action_id
1495: AND asa.payroll_action_id = pya.payroll_action_id