APPS.PAY_ARCH_MISSING_ASG_PKG dependencies on DUAL

Line 322: FROM dual;

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

Line 466: FROM dual;

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

Line 555: FROM DUAL

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

Line 586: c_non_zero_run_result := 'SELECT 1 FROM dual

582: else -- Run Balance Status is 'N'
583: hr_utility.trace('opened c_non_zero_run_result');
584:
585: l_step := 4;
586: c_non_zero_run_result := 'SELECT 1 FROM dual
587: WHERE EXISTS (SELECT 1
588: FROM pay_run_results prr,
589: pay_run_result_values prrv,
590: pay_input_values_f piv,