APPS.PAY_SE_INCOME_STATEMENT dependencies on DUAL

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

806: WHEN OTHERS
807: THEN
808: -- Return cursor that selects no rows
809: p_sql :=
810: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
811: END range_code;
812:
813: /* ASSIGNMENT ACTION CODE */
814: PROCEDURE assignment_action_code (

Line 1178: FROM DUAL;

1174: IF l_a_tax_card_or_not > 0
1175: THEN
1176: SELECT pay_assignment_actions_s.NEXTVAL
1177: INTO l_actid
1178: FROM DUAL;
1179:
1180: -- Create the archive assignment action
1181: hr_nonrun_asact.insact
1182: (l_actid

Line 1232: FROM DUAL;

1228: IF l_a_tax_card_or_not > 0
1229: THEN
1230: SELECT pay_assignment_actions_s.NEXTVAL
1231: INTO l_actid
1232: FROM DUAL;
1233:
1234: -- Create the archive assignment action
1235: hr_nonrun_asact.insact
1236: (l_actid

Line 1290: FROM DUAL;

1286: IF l_a_tax_card_or_not > 0
1287: THEN
1288: SELECT pay_assignment_actions_s.NEXTVAL
1289: INTO l_actid
1290: FROM DUAL;
1291:
1292: -- Create the archive assignment action
1293: hr_nonrun_asact.insact
1294: (l_actid

Line 1345: FROM DUAL;

1341: IF l_a_tax_card_or_not > 0
1342: THEN
1343: SELECT pay_assignment_actions_s.NEXTVAL
1344: INTO l_actid
1345: FROM DUAL;
1346:
1347: -- Create the archive assignment action
1348: hr_nonrun_asact.insact
1349: (l_actid