APPS.PAY_ARCH_MISSING_ASG_PKG dependencies on DUAL

Line 325: FROM dual;

321:
322:
323: SELECT pay_assignment_actions_s.nextval
324: INTO lockingactid
325: FROM dual;
326:
327: l_step := 5;
328: -- insert the action record.
329: hr_nonrun_asact.insact --no change

Line 469: FROM dual;

465: ) IS
466:
467: CURSOR c_get_session_id IS
468: SELECT userenv('sessionid')
469: FROM dual;
470:
471: -- Get legislation code
472: CURSOR c_get_leg_code(cp_business_group_id NUMBER
473: ) IS

Line 558: FROM DUAL

554: l_step := 2;
555: hr_utility.trace('opened c_non_zero_run_balance');
556: --hr_utility.trace(ltr_def_bal_status(lv_count).attribute_id);
557: c_non_zero_run_balance := 'SELECT 1
558: FROM DUAL
559: WHERE EXISTS(
560: select 1
561: from pay_run_balances prb,
562: pay_balance_attributes pba,

Line 591: c_non_zero_run_result := 'SELECT 1 FROM dual

587: else -- Run Balance Status is 'N'
588: hr_utility.trace('opened c_non_zero_run_result');
589:
590: l_step := 4;
591: c_non_zero_run_result := 'SELECT 1 FROM dual
592: WHERE EXISTS (SELECT 1
593: FROM pay_run_results prr,
594: pay_run_result_values prrv,
595: pay_input_values_f piv,