APPS.PAY_US_INS_ORG_INFO_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 81: -- FROM hr_organization_information hoi

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
83: -- , hr_org_information_types oit
84: -- WHERE oit.org_information_type = p_org_information_context
85: -- AND oit.org_information_type = tbc.org_information_type

Line 105: FROM hr_organization_information

101: begin
102: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',15);
103: SELECT 'Y'
104: INTO l_check
105: FROM hr_organization_information
106: WHERE organization_id = l_organization_id
107: AND org_information_context = l_org_information_type
108: AND org_information1 = l_org_information1;
109: --

Line 121: SELECT hr_organization_information_s.nextval

117: exception when NO_DATA_FOUND then null;
118: end;
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));

Line 132: INSERT INTO HR_ORGANIZATION_INFORMATION

128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);
131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);
132: INSERT INTO HR_ORGANIZATION_INFORMATION
133: (org_information_id
134: ,organization_id
135: ,attribute_category
136: ,org_information_context