APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_STR_TO_TABLE_GT

Line 1188: FROM jty_str_to_table_gt)

1184: AND(v_active BETWEEN terr.start_date_active
1185: AND terr.end_date_active OR v_active IS NULL) CONNECT BY terr.parent_territory_id = PRIOR terr.terr_id
1186: AND terr.terr_id <> 1 START WITH terr.terr_id IN
1187: (SELECT num_col
1188: FROM jty_str_to_table_gt)
1189: ORDER siblings BY terr.terr_id)
1190: sub
1191: WHERE sub.org_id = hr.organization_id
1192: AND sub.terr_type_id = terr_type.terr_type_id;

Line 1443: --EXECUTE IMMEDIATE ('TRUNCATE TABLE JTY_STR_TO_TABLE_GT');

1439: --p( l_cur_query );
1440:
1441: IF p_terr_id_array IS NOT NULL THEN
1442: BEGIN
1443: --EXECUTE IMMEDIATE ('TRUNCATE TABLE JTY_STR_TO_TABLE_GT');
1444:
1445: DELETE FROM jty_str_to_table_gt;
1446: l_string := p_terr_id_array || ',';
1447: LOOP

Line 1445: DELETE FROM jty_str_to_table_gt;

1441: IF p_terr_id_array IS NOT NULL THEN
1442: BEGIN
1443: --EXECUTE IMMEDIATE ('TRUNCATE TABLE JTY_STR_TO_TABLE_GT');
1444:
1445: DELETE FROM jty_str_to_table_gt;
1446: l_string := p_terr_id_array || ',';
1447: LOOP
1448: EXIT
1449: WHEN l_string IS NULL;

Line 1455: INTO jty_str_to_table_gt(num_col)

1451: l_value := SUBSTR(l_string, 1, l_cnt -1);
1452:
1453: IF l_value IS NOT NULL THEN
1454: INSERT
1455: INTO jty_str_to_table_gt(num_col)
1456: VALUES(l_value);
1457: END IF;
1458:
1459: l_string := SUBSTR(l_string, l_cnt + 1);