APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 46: FROM hz_party_sites_v ps, hr_organization_information hr

42: site_use_type,
43: primary_per_type
44: FROM (
45: SELECT party_site_id, ps.site_use_type, ps.primary_per_type
46: FROM hz_party_sites_v ps, hr_organization_information hr
47: WHERE ps.party_id = c_party_id
48: AND ps.status = 'A'
49: AND nvl(ps.end_date_active, sysdate + 1) > sysdate
50: AND hr.organization_id = c_org_id

Line 61: FROM hr_organization_information hr

57: AND ps.status = 'A'
58: AND nvl(ps.end_date_active,sysdate + 1) > sysdate
59: AND NOT EXISTS (
60: SELECT 1
61: FROM hr_organization_information hr
62: WHERE hr.organization_id = c_org_id
63: AND hr.org_information_context = c_hr_type
64: AND rownum = 1
65: )