APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_WEBADI_QUAL_TYPE_HEADER

Line 118: DELETE FROM jty_webadi_qual_type_header

114: PROCEDURE get_qual_type_header(p_usage_id IN INTEGER, p_user_sequence IN INTEGER) IS
115:
116: BEGIN
117:
118: DELETE FROM jty_webadi_qual_type_header
119: WHERE user_sequence = p_user_sequence;
120:
121: INSERT
122: INTO jty_webadi_qual_type_header(qual_type_id, qual_type_num, qual_type_name, qual_type_descr, user_sequence)

Line 122: INTO jty_webadi_qual_type_header(qual_type_id, qual_type_num, qual_type_name, qual_type_descr, user_sequence)

118: DELETE FROM jty_webadi_qual_type_header
119: WHERE user_sequence = p_user_sequence;
120:
121: INSERT
122: INTO jty_webadi_qual_type_header(qual_type_id, qual_type_num, qual_type_name, qual_type_descr, user_sequence)
123: (SELECT jqtu.qual_type_usg_id qual_type_id,
124: rownum,
125: jqt.name qual_type_name,
126: jqt.description qual_type_descr,

Line 1304: jty_webadi_qual_type_header jqth,

1300: MAX(decode(jqth.qual_type_num, 10, jtra.terr_rsc_access_id, NULL)) terr_rsc_access_id10,
1301: MAX(decode(jqth.qual_type_num, 10, fnd.description, NULL)) qual_type10_val
1302: FROM jtf_sources_all jsa,
1303: jtf_terr_rsc_access_all jtra,
1304: jty_webadi_qual_type_header jqth,
1305: jtf_terr_rsc_all jtr,
1306: fnd_lookups fnd
1307: WHERE jsa.rsc_access_lkup = fnd.lookup_type
1308: AND jsa.source_id = p_usage_id