DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on DUAL

Line 816: 'select 1 from dual where to_char(:payroll_action_id) = dummy';

812: WHEN OTHERS
813: THEN
814: -- Return cursor that selects no rows
815: p_sql :=
816: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
817: END range_code;
818:
819: /* ASSIGNMENT ACTION CODE */
820: PROCEDURE assignment_action_code (

Line 1184: FROM DUAL;

1180: IF l_a_tax_card_or_not > 0
1181: THEN
1182: SELECT pay_assignment_actions_s.NEXTVAL
1183: INTO l_actid
1184: FROM DUAL;
1185:
1186: -- Create the archive assignment action
1187: hr_nonrun_asact.insact
1188: (l_actid

Line 1238: FROM DUAL;

1234: IF l_a_tax_card_or_not > 0
1235: THEN
1236: SELECT pay_assignment_actions_s.NEXTVAL
1237: INTO l_actid
1238: FROM DUAL;
1239:
1240: -- Create the archive assignment action
1241: hr_nonrun_asact.insact
1242: (l_actid

Line 1296: FROM DUAL;

1292: IF l_a_tax_card_or_not > 0
1293: THEN
1294: SELECT pay_assignment_actions_s.NEXTVAL
1295: INTO l_actid
1296: FROM DUAL;
1297:
1298: -- Create the archive assignment action
1299: hr_nonrun_asact.insact
1300: (l_actid

Line 1351: FROM DUAL;

1347: IF l_a_tax_card_or_not > 0
1348: THEN
1349: SELECT pay_assignment_actions_s.NEXTVAL
1350: INTO l_actid
1351: FROM DUAL;
1352:
1353: -- Create the archive assignment action
1354: hr_nonrun_asact.insact
1355: (l_actid