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 218: from hr_organization_information ori

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

Line 1000: from hr_organization_information ori

996: (c_bgp_id in number
997: )
998: Is
999: select to_number(ori.ORG_INFORMATION2)
1000: from hr_organization_information ori
1001: where ori.organization_id = c_bgp_id
1002: and ori.ORG_INFORMATION_CONTEXT = 'Benefits Defaults';
1003: l_mthpayroll_id number := null;
1004: begin