APPS.PAY_IE_P35 dependencies on DUAL

Line 1101: FROM DUAL;

1097: IF l_flag_exclusion <> 'Y' then
1098: IF l_flag_action_type not in ('I','B','V') then
1099: SELECT pay_assignment_actions_s.NEXTVAL
1100: INTO l_actid
1101: FROM DUAL;
1102:
1103: hr_utility.set_location('INSIDE IF',18);
1104: hr_utility.set_location('Insert asg actions asg_id '||to_char(csr_select_asg_rec.assignment_id),18);
1105: hr_utility.set_location('Insert asg actions l_actid '||to_char(l_actid),18);

Line 1127: FROM DUAL;

1123:
1124: IF l_flag_exclusion <> 'Y' then
1125: SELECT pay_assignment_actions_s.NEXTVAL
1126: INTO l_actid
1127: FROM DUAL;
1128: hr_utility.set_location('INSIDE ELSE',18);
1129: hr_utility.set_location('Insert asg actions asg_id '||to_char(csr_select_asg_rec.assignment_id),18);
1130: hr_utility.set_location('Insert asg actions l_actid '||to_char(l_actid),18);
1131: hr_utility.set_location('Insert asg actions pactid '||to_char(pactid),18);

Line 2953: FROM DUAL;

2949: 1, '0',
2950: '0'
2951: )
2952: INTO l_arch_tax_or_refund
2953: FROM DUAL;
2954:
2955:
2956: hr_utility.set_location('l_arch_tax_or_refund..'||l_arch_tax_or_refund,1005);
2957: hr_utility.set_location('b4 cursor csr_p30_found..',1005);

Line 4126: FROM DUAL;

4122: */
4123: hr_utility.set_location('Inside Else ..',2002);
4124: SELECT pay_assignment_actions_s.NEXTVAL
4125: INTO l_actid
4126: FROM DUAL;
4127: OPEN get_assignment_id;
4128: FETCH get_assignment_id into v_payroll_action_id,v_assignment_id,v_chunk;
4129: CLOSE get_assignment_id;
4130: hr_nonrun_asact.insact (l_actid,

Line 4549: FROM DUAL

4545:
4546:
4547: CURSOR csr_check_payroll_action IS
4548: SELECT 1
4549: FROM DUAL
4550: WHERE EXISTS (SELECT NULL
4551: FROM pay_action_information pai
4552: WHERE pai.action_context_id = p_payroll_action_id
4553: AND pai.action_context_type = 'PA'