DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on DUAL

Line 449: from dual;

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

Line 780: from sys.dual;

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

Line 1046: from sys.dual

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

Line 1930: from sys.dual;

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