DBA Data[Home] [Help]

APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on HR_OPERATING_UNITS

Line 974: FROM hr_operating_units hr,

970: terr.attribute12,
971: terr.attribute13,
972: terr.attribute14,
973: terr.attribute15
974: FROM hr_operating_units hr,
975: jtf_terr_types_all terr_type,
976: jtf_terr_all terr,
977: (SELECT MAX(sys_connect_by_path(REVERSE(terr.name), '/')) hierarchy
978: FROM jtf_terr_all terr

Line 1015: FROM hr_operating_units hr,

1011: sub.attribute12,
1012: sub.attribute13,
1013: sub.attribute14,
1014: sub.attribute15
1015: FROM hr_operating_units hr,
1016: jtf_terr_types_all terr_type,
1017: (SELECT terr.terr_id terr_id,
1018: terr.name terr_name,
1019: sys_connect_by_path(terr.name, '->') hierarchy,

Line 1083: FROM hr_operating_units hr,

1079: sub.attribute12,
1080: sub.attribute13,
1081: sub.attribute14,
1082: sub.attribute15
1083: FROM hr_operating_units hr,
1084: jtf_terr_types_all terr_type,
1085: (SELECT terr.terr_id terr_id,
1086: terr.name terr_name,
1087: sys_connect_by_path(terr.name, '->') hierarchy,

Line 1152: FROM hr_operating_units hr,

1148: sub.attribute12,
1149: sub.attribute13,
1150: sub.attribute14,
1151: sub.attribute15
1152: FROM hr_operating_units hr,
1153: jtf_terr_types_all terr_type,
1154: (SELECT terr.terr_id terr_id,
1155: terr.name terr_name,
1156: sys_connect_by_path(terr.name, '->') hierarchy,