DBA Data[Home] [Help]

APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on DUAL

Line 857: from dual;

853: l_prev_asg_act_id := p_asg_action_id;
854: if (g_inserted_asg_action_id_flag = 'N') then
855: select pay_assignment_actions_s.nextval
856: into new_asg_act_id
857: from dual;
858:
859: -- insert the action record.
860: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));
861: hr_utility.trace('Assignment id: '||to_char(p_asg_id));

Line 1323: from dual;

1319: l_prev_asg_act_id := p_asg_action_id;
1320:
1321: select pay_assignment_actions_s.nextval
1322: into new_asg_act_id
1323: from dual;
1324:
1325: -- insert the action record.
1326: hr_utility.trace('New Assignment action id: '||to_char(new_asg_act_id));
1327: hr_utility.trace('Assignment id: '||to_char(p_asg_id));

Line 1633: from dual;

1629:
1630: if p_insert_done_flag = 'N' then
1631: select pay_assignment_actions_s.nextval
1632: into new_asg_act_id
1633: from dual;
1634:
1635: --insert the action record
1636: hr_nonrun_asact.insact(new_asg_act_id,p_assignment_id,pactid,chnkno,p_tax_unit_id);
1637: p_insert_done_flag := 'Y';