DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_API dependencies on HR_ORGANIZATION_INFORMATION

Line 21: from hr_organization_information hoi

17:
18:
19: cursor ben_assign_ok is
20: select substr(hoi.ORG_INFORMATION3,1)
21: from hr_organization_information hoi
22: where hoi.org_information_context = 'Benefits Defaults'
23: and hoi.organization_id = p_business_group_id;
24:
25: l_status varchar2(1);

Line 217: from hr_organization_information ori

213: (c_bgp_id in number
214: )
215: Is
216: select to_number(ori.ORG_INFORMATION2)
217: from hr_organization_information ori
218: where ori.organization_id = c_bgp_id
219: and ori.ORG_INFORMATION_CONTEXT = 'Benefits Defaults';
220: --
221: -- Begin of bug 1919015

Line 973: from hr_organization_information ori

969: (c_bgp_id in number
970: )
971: Is
972: select to_number(ori.ORG_INFORMATION2)
973: from hr_organization_information ori
974: where ori.organization_id = c_bgp_id
975: and ori.ORG_INFORMATION_CONTEXT = 'Benefits Defaults';
976: l_mthpayroll_id number := null;
977: begin