APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on HR_OPERATING_UNITS

Line 1429: FROM hr_operating_units hr,

1425: terr.attribute12,
1426: terr.attribute13,
1427: terr.attribute14,
1428: terr.attribute15
1429: FROM hr_operating_units hr,
1430: jtf_terr_types_all terr_type,
1431: jtf_terr_all terr,
1432: (SELECT MAX(sys_connect_by_path(REVERSE(terr.name), '/')) hierarchy
1433: FROM jtf_terr_all terr

Line 1470: FROM hr_operating_units hr,

1466: sub.attribute12,
1467: sub.attribute13,
1468: sub.attribute14,
1469: sub.attribute15
1470: FROM hr_operating_units hr,
1471: jtf_terr_types_all terr_type,
1472: (SELECT terr.terr_id terr_id,
1473: terr.name terr_name,
1474: sys_connect_by_path(terr.name, '->') hierarchy,

Line 1538: FROM hr_operating_units hr,

1534: sub.attribute12,
1535: sub.attribute13,
1536: sub.attribute14,
1537: sub.attribute15
1538: FROM hr_operating_units hr,
1539: jtf_terr_types_all terr_type,
1540: (SELECT terr.terr_id terr_id,
1541: terr.name terr_name,
1542: sys_connect_by_path(terr.name, '->') hierarchy,

Line 1607: FROM hr_operating_units hr,

1603: sub.attribute12,
1604: sub.attribute13,
1605: sub.attribute14,
1606: sub.attribute15
1607: FROM hr_operating_units hr,
1608: jtf_terr_types_all terr_type,
1609: (SELECT terr.terr_id terr_id,
1610: terr.name terr_name,
1611: sys_connect_by_path(terr.name, '->') hierarchy,