APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_WEBADI_QUAL_TYPE_HEADER

Line 111: DELETE FROM jty_webadi_qual_type_header

107: PROCEDURE get_qual_type_header(p_usage_id IN INTEGER, p_user_sequence IN INTEGER) IS
108:
109: BEGIN
110:
111: DELETE FROM jty_webadi_qual_type_header
112: WHERE user_sequence = p_user_sequence;
113:
114: INSERT
115: INTO jty_webadi_qual_type_header(qual_type_id, qual_type_num, qual_type_name, qual_type_descr, user_sequence)

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

111: DELETE FROM jty_webadi_qual_type_header
112: WHERE user_sequence = p_user_sequence;
113:
114: INSERT
115: INTO jty_webadi_qual_type_header(qual_type_id, qual_type_num, qual_type_name, qual_type_descr, user_sequence)
116: (SELECT jqtu.qual_type_usg_id qual_type_id,
117: rownum,
118: jqt.name qual_type_name,
119: jqt.description qual_type_descr,

Line 849: jty_webadi_qual_type_header jqth,

845: MAX(decode(jqth.qual_type_num, 10, jtra.terr_rsc_access_id, NULL)) terr_rsc_access_id10,
846: MAX(decode(jqth.qual_type_num, 10, fnd.description, NULL)) qual_type10_val
847: FROM jtf_sources_all jsa,
848: jtf_terr_rsc_access_all jtra,
849: jty_webadi_qual_type_header jqth,
850: jtf_terr_rsc_all jtr,
851: fnd_lookups fnd
852: WHERE jsa.rsc_access_lkup = fnd.lookup_type
853: AND jsa.source_id = p_usage_id