DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_AUDIT_UNITS_V

Line 1669: from amw_audit_units_v

1665: and watl.language = userenv('LANG');
1666:
1667: select name
1668: into l_org_name
1669: from amw_audit_units_v
1670: where organization_id = p_org_id;
1671:
1672: else
1673: l_person_id := 0;

Line 2613: where organization_id in (select distinct organization_id from amw_audit_units_v)

2609: begin
2610: select org_information2
2611: into l_dummy
2612: from hr_organization_information
2613: where organization_id in (select distinct organization_id from amw_audit_units_v)
2614: and org_information_context = 'Organization Name Alias'
2615: and org_information2 = l_empid;
2616: exception
2617: when no_data_found then

Line 2651: from hr_organization_information hoi, amw_audit_units_v aauv

2647: hier_name varchar2(30);
2648:
2649: cursor c_orgs(l_emp number) is
2650: select hoi.organization_id
2651: from hr_organization_information hoi, amw_audit_units_v aauv
2652: where hoi.organization_id = aauv.organization_id
2653: and hoi.org_information_context = 'Organization Name Alias'
2654: and hoi.org_information2 = l_emp;
2655: