APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTY_WEBADI_QUAL_HEADER

Line 516: from JTY_WEBADI_QUAL_HEADER jqh,

512: v_user_sequence number,
513: v_intf_type varchar2,
514: v_header varchar2) IS
515: select jqh.qualifier_name, sub.lay_seq_num
516: from JTY_WEBADI_QUAL_HEADER jqh,
517: (
518: select jut.lay_seq_num, jut.user_sequence, jut.terr_type_id,
519: 1 qual_num
520: FROM JTY_WEBADI_OTH_TERR_INTF jut

Line 1895: from JTY_WEBADI_QUAL_HEADER qgt , jtf_terr_qual_all jtq, JTY_WEBADI_OTH_TERR_INTF jwot

1891: v_intf_type varchar2,
1892: v_qual_num number
1893: ) IS
1894: select jtq.terr_qual_id, jwot.lay_seq_num
1895: from JTY_WEBADI_QUAL_HEADER qgt , jtf_terr_qual_all jtq, JTY_WEBADI_OTH_TERR_INTF jwot
1896: WHERE qgt.qual_usg_id = jtq.qual_usg_id
1897: and jtq.org_id = jwot.org_id
1898: AND qgt.user_sequence = jwot.user_sequence
1899: AND jtq.terr_id = jwot.terr_id

Line 5052: from JTY_WEBADI_QUAL_HEADER jq,

5048: when (jq.COMPARISON_OPERATOR LIKE '%LIKE%') AND (instr(sub.qual_VALUE1,'_') > 0) or (instr(sub.qual_VALUE1,'%') > 0 and sub.qual_VALUE2 is null) then 'LIKE'
5049: when (jq.COMPARISON_OPERATOR LIKE '%BETWEEN%') AND (sub.qual_VALUE1 is not null and sub.qual_VALUE2 is not null) then 'BETWEEN'
5050: else '='
5051: end) qual_cond
5052: from JTY_WEBADI_QUAL_HEADER jq,
5053: (
5054: select terr_id, user_sequence,
5055: 1 qual_num, QUAL1_VALUE_ID qual_value_id,
5056: QUAL1_VALUE1 qual_VALUE1,

Line 6274: from JTY_WEBADI_QUAL_HEADER jq,

6270: when (jq.COMPARISON_OPERATOR LIKE '%LIKE%') AND (instr(sub.qual_VALUE1,'_') > 0) or (instr(sub.qual_VALUE1,'%') > 0 and sub.qual_VALUE2 is null) then 'LIKE'
6271: when (jq.COMPARISON_OPERATOR LIKE '%BETWEEN%') AND (sub.qual_VALUE1 is not null and sub.qual_VALUE2 is not null) then 'BETWEEN'
6272: else '='
6273: end) qual_cond
6274: from JTY_WEBADI_QUAL_HEADER jq,
6275: (
6276: select terr_id, user_sequence,
6277: terr_qual_id1 terr_qual_id,
6278: 1 qual_num, QUAL1_VALUE_ID qual_value_id,

Line 7571: from JTY_WEBADI_QUAL_HEADER jq,

7567: when (jq.COMPARISON_OPERATOR LIKE '%LIKE%') AND (instr(sub.qual_VALUE1,'_') > 0) or (instr(sub.qual_VALUE1,'%') > 0 and sub.qual_VALUE2 is null) then 'LIKE'
7568: when (jq.COMPARISON_OPERATOR LIKE '%BETWEEN%') AND (sub.qual_VALUE1 is not null and sub.qual_VALUE2 is not null) then 'BETWEEN'
7569: else '='
7570: end) qual_cond
7571: from JTY_WEBADI_QUAL_HEADER jq,
7572: (
7573: select terr_id, user_sequence,
7574: terr_qual_id1 terr_qual_id,
7575: 1 qual_num, QUAL1_VALUE_ID qual_value_id,