APPS.POA_REPORT_UTIL dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 753: (SELECT organization_id FROM org_organization_definitions

749: SELECT hr.organization_id
750: FROM hr_organization_units hr
751: WHERE hr.name = p_org_name
752: AND (hr.organization_id IN
753: (SELECT organization_id FROM org_organization_definitions
754: WHERE set_of_books_id IN
755: (SELECT id
756: FROM bis_sets_of_books_v
757: WHERE responsibility_id IN

Line 1025: || ' (SELECT organization_id FROM org_organization_definitions '

1021: l_where_clause := ' 1 = 2 '
1022: || ' UNION SELECT DISTINCT VALUE, ID '
1023: || ' FROM ' || l_database_object
1024: || ' WHERE ID IN '
1025: || ' (SELECT organization_id FROM org_organization_definitions '
1026: || ' WHERE set_of_books_id IN ( ';
1027:
1028:
1029: FOR i IN 1..l_SOB_tbl.COUNT LOOP