APPS.PAY_IE_P35 dependencies on DUAL

Line 1036: FROM DUAL;

1032: null,
1033: null,
1034: 'TRUE'
1035: )
1036: FROM DUAL;
1037:
1038: l_levi_amount number := 0;
1039: --8874161
1040:

Line 1158: FROM DUAL;

1154: null,
1155: null,
1156: 'TRUE'
1157: ) taxable_pay
1158: FROM DUAL;
1159:
1160: l_usc_amount number := 0;
1161: l_prsi_amount number := 0;
1162: l_tax_amount number := 0;

Line 1327: FROM DUAL;

1323: IF l_count <> 0 OR l_levi_amount <> 0
1324: OR l_usc_amount <> 0 OR l_prsi_amount <> 0 OR l_tax_amount <> 0 THEN --8874161 --12382953
1325: SELECT pay_assignment_actions_s.NEXTVAL
1326: INTO l_actid
1327: FROM DUAL;
1328:
1329: hr_utility.set_location('INSIDE IF',18);
1330: hr_utility.set_location('Insert asg actions asg_id '||to_char(csr_select_asg_rec.assignment_id),18);
1331: hr_utility.set_location('Insert asg actions l_actid '||to_char(l_actid),18);

Line 1354: FROM DUAL;

1350: IF l_flag_exclusion <> 'Y' then
1351: IF l_flag_action_type not in ('I','B','V') then
1352: SELECT pay_assignment_actions_s.NEXTVAL
1353: INTO l_actid
1354: FROM DUAL;
1355:
1356: hr_utility.set_location('INSIDE IF',18);
1357: hr_utility.set_location('Insert asg actions asg_id '||to_char(csr_select_asg_rec.assignment_id),18);
1358: hr_utility.set_location('Insert asg actions l_actid '||to_char(l_actid),18);

Line 1380: FROM DUAL;

1376:
1377: IF l_flag_exclusion <> 'Y' then
1378: SELECT pay_assignment_actions_s.NEXTVAL
1379: INTO l_actid
1380: FROM DUAL;
1381: hr_utility.set_location('INSIDE ELSE',18);
1382: hr_utility.set_location('Insert asg actions asg_id '||to_char(csr_select_asg_rec.assignment_id),18);
1383: hr_utility.set_location('Insert asg actions l_actid '||to_char(l_actid),18);
1384: hr_utility.set_location('Insert asg actions pactid '||to_char(pactid),18);

Line 3972: FROM DUAL;

3968: 1, '0',
3969: '0'
3970: )
3971: INTO l_arch_tax_or_refund
3972: FROM DUAL;
3973:
3974:
3975: hr_utility.set_location('l_arch_tax_or_refund..'||l_arch_tax_or_refund,1005);
3976: hr_utility.set_location('b4 cursor csr_p30_found..',1005);

Line 6834: FROM DUAL;

6830: */
6831: hr_utility.set_location('Inside Else ..',2002);
6832: SELECT pay_assignment_actions_s.NEXTVAL
6833: INTO l_actid
6834: FROM DUAL;
6835: OPEN get_assignment_id;
6836: FETCH get_assignment_id into v_payroll_action_id,v_assignment_id,v_chunk;
6837: CLOSE get_assignment_id;
6838: hr_nonrun_asact.insact (l_actid,

Line 7575: FROM DUAL

7571:
7572:
7573: CURSOR csr_check_payroll_action IS
7574: SELECT 1
7575: FROM DUAL
7576: WHERE EXISTS (SELECT NULL
7577: FROM pay_action_information pai
7578: WHERE pai.action_context_id = p_payroll_action_id
7579: AND pai.action_context_type = 'PA'