DBA Data[Home] [Help]

APPS.PAY_FR_DB_PAY_SETUP dependencies on DUAL

Line 447: from dual;

443: -- Select the sequence number for input value. This can then be passed back
444: -- via the function for later use.
445: select pay_input_values_s.nextval
446: into v_input_value_id
447: from dual;
448: --
449: if g_debug then
450: hr_utility.set_location('pay_db_pay_setup.create_input_value',15);
451: end if;

Line 778: from sys.dual;

774: -- Select the sequence number for the payroll. This can then be passed back
775: -- via the function for later use.
776: select pay_payrolls_s.nextval
777: into v_payroll_id
778: from sys.dual;
779: --
780: if g_debug then
781: hr_utility.set_location('pay_db_pay_setup.create_payroll',2);
782: end if;

Line 1044: from sys.dual

1040: SESSION_ID)
1041: select
1042: p_app_short_name,
1043: userenv('sessionid')
1044: from sys.dual
1045: where not exists (select 1
1046: from hr_owner_definitions od
1047: where od.product_short_name = p_app_short_name
1048: and session_id = userenv('sessionid'));

Line 1929: from sys.dual;

1925: --
1926: -- Get sequence for
1927: select pay_balance_classifications_s.nextval
1928: into v_balance_classification_id
1929: from sys.dual;
1930: --
1931: if g_debug then
1932: hr_utility.set_location('pay_db_pay_setup.create_balance_classification',2);
1933: end if;