DBA Data[Home] [Help]

APPS.POA_DBI_SUTIL_PKG dependencies on PER_ORGANIZATION_LIST

Line 682: --l_in_join_rec.table_name := 'per_organization_list';

678: if(l_ou_value is null or
679: l_ou_value = '' or
680: l_ou_value = 'All') then
681: null;
682: --l_in_join_rec.table_name := 'per_organization_list';
683: --l_in_join_rec.table_alias := 'orgl';
684: --p_in_join_tbl.extend;
685: --p_in_join_tbl(p_in_join_tbl.count) := l_in_join_rec;
686:

Line 1579: per_organization_list per

1575: THEN
1576: ---End changes for MOAC
1577: select count(*) into l_exists
1578: from fii_operating_units_v v,
1579: per_organization_list per
1580: where v.id = p_ou_id
1581: and v.id = per.organization_id
1582: and security_profile_id = l_sec_profile_id ;
1583: ---Begin changes for MOAC