APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on DUAL

Line 747: from dual;

743: 0, DECODE(INSTR(l_leg_param, p_token), 0, .5, LENGTH(l_leg_param)),
744: INSTR(l_leg_param, ' ', INSTR(l_leg_param, p_token))
745: - (INSTR(l_leg_param, p_token) + (LENGTH(p_token) + 1)))))
746: into l_ret
747: from dual;
748: return l_ret; */
749: x := instr(l_leg_param,p_token);
750: y := length(p_token);
751: if instr(l_leg_param, ' ', x) <> 0 then

Line 888: FROM DUAL;

884: THEN
885: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
886: SELECT pay_assignment_actions_s.NEXTVAL
887: INTO l_actid
888: FROM DUAL;
889:
890: hr_utility.set_location('Archive assignment Action ', 30);
891: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
892: l_prev_assignment_id := csr_rec.assignment_id;

Line 920: FROM DUAL;

916: THEN
917: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
918: SELECT pay_assignment_actions_s.NEXTVAL
919: INTO l_actid
920: FROM DUAL;
921:
922: hr_utility.set_location('Archive assignment Action ', 30);
923: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
924: l_prev_assignment_id := csr_rec.assignment_id;

Line 953: FROM DUAL;

949: THEN
950: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
951: SELECT pay_assignment_actions_s.NEXTVAL
952: INTO l_actid
953: FROM DUAL;
954: hr_utility.set_location('Archive assignment Action ', 30);
955: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
956: l_prev_assignment_id := csr_rec.assignment_id;
957: hr_utility.TRACE(' Created Assignment action ');

Line 1826: from dual

1822:
1823: cursor c_get_updated_status (c_person_id in number,
1824: c_payroll_action_id in number) is
1825: select 'Y'
1826: from dual
1827: where exists (select 'X'
1828: from pay_action_information pai,
1829: pay_assignment_actions paa,
1830: per_all_assignments_f paaf

Line 2673: from dual;

2669: close csr_ni;
2670:
2671: select hr_gb_utility.ni_validate(l_nat_number,p_eff_date)
2672: into l_var_value
2673: from dual;
2674:
2675: if l_var_value <> 0 then
2676: -- Setup warning message
2677: l_warn:=1;

Line 4381: select length(l_msg) into l_msg_length from dual;

4377: l_count number;
4378: l_temp number;
4379: l_pos number;
4380: BEGIN
4381: select length(l_msg) into l_msg_length from dual;
4382: l_first := true;
4383: while l_msg_length > 57 loop
4384: l_count := 1;
4385: l_pos := 0;

Line 4389: select instr(l_msg,' ',1,l_count) into l_temp from dual;

4385: l_pos := 0;
4386: l_temp := 1;
4387: while l_temp > 0 and l_temp < 56 loop
4388: l_pos := l_temp;
4389: select instr(l_msg,' ',1,l_count) into l_temp from dual;
4390: l_count := l_count + 1;
4391: end loop;
4392: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4393: select length(l_msg) into l_msg_length from dual;

Line 4392: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;

4388: l_pos := l_temp;
4389: select instr(l_msg,' ',1,l_count) into l_temp from dual;
4390: l_count := l_count + 1;
4391: end loop;
4392: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4393: select length(l_msg) into l_msg_length from dual;
4394: if l_first then
4395: l_first := false;
4396: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||

Line 4393: select length(l_msg) into l_msg_length from dual;

4389: select instr(l_msg,' ',1,l_count) into l_temp from dual;
4390: l_count := l_count + 1;
4391: end loop;
4392: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4393: select length(l_msg) into l_msg_length from dual;
4394: if l_first then
4395: l_first := false;
4396: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||
4397: rpad(p_emp_no, 17) || ' ' ||