DBA Data[Home] [Help]

APPS.PAY_US_INS_ORG_INFO_PKG dependencies on DUAL

Line 78: SELECT 'x' INTO l_dummy from dual;

74: hr_utility.trace('l_organization_id '||to_char(l_organization_id));
75: --
76: --
77: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);
78: SELECT 'x' INTO l_dummy from dual;
79: -- SELECT oit.org_information_type
80: -- INTO l_org_information_type
81: -- FROM hr_organization_information hoi
82: -- , hr_org_info_types_by_class tbc

Line 123: FROM sys.dual;

119: --
120: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',20);
121: SELECT hr_organization_information_s.nextval
122: INTO l_org_information_id
123: FROM sys.dual;
124: --
125: -- hr_utility.trace('l_org_information_id is ' || to_char(l_org_information_id));
126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));
127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));