APPS.PAY_SG_IRAS_MAGTAPE dependencies on DUAL

Line 110: from dual;

106: v_type ff_database_items.user_name%type;
107:
108: cursor next_action_id is
109: select pay_assignment_actions_s.nextval
110: from dual;
111:
112: cursor process_assignments
113: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
114: c_start_person_id in per_all_people_f.person_id%type,

Line 207: into v_type from dual;

203:
204: initialization_code(p_payroll_action_id);
205:
206: select decode(g_file,'IR8A', 'X_IR8A_AMEND_INDICATOR','IR8S', 'X_IR8S_AMEND_INDICATOR','A8A','X_A8A_AMEND_INDICATOR','A8B','X_A8B_AMEND_INDICATOR')
207: into v_type from dual;
208:
209: for process_rec in process_assignments (p_payroll_action_id,
210: p_start_person_id,
211: p_end_person_id,