DBA Data[Home] [Help]

APPS.PAY_INPUT_VALUES_PKG dependencies on DUAL

Line 245: from dual

241: v_value_exists boolean := FALSE;
242: --
243: cursor csr_value is
244: select 1
245: from dual
246: where exists
247: (select /*+ INDEX(RESULT PAY_RUN_RESULTS_PK) */ 1
248: from pay_run_result_values VALUE,
249: pay_run_results RESULT,

Line 612: residual_input_value_id );

608: select 1
609: from pay_accrual_plans
610: where p_input_value_id in ( pto_input_value_id,
611: co_input_value_id,
612: residual_input_value_id );
613: --
614: begin
615: --
616: hr_utility.set_location ('PAY_INPUT_VALUES_PKG.ACCRUAL_PLAN_EXISTS',1);

Line 1068: from sys.dual;

1064: ) is
1065: --
1066: cursor csr_next_id is
1067: select pay_input_values_s.nextval
1068: from sys.dual;
1069: --
1070: cursor csr_input_value_rowid is
1071: --
1072: /* We need to know the value of the newly created

Line 1251: from dual;

1247: c_login_id,
1248: sysdate,
1249: c_lang_rec.language_code,
1250: userenv('LANG')
1251: from dual;
1252:
1253: end loop;
1254:
1255: --