APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTY_WEBADI_QUAL_TYPE_HEADER

Line 2499: from JTY_WEBADI_QUAL_TYPE_HEADER gt,

2495: LAST_UPDATE_LOGIN,
2496: TERR_ID,
2497: QUAL_TYPE_ID QUAL_TYPE_USG_ID,
2498: ORG_ID
2499: from JTY_WEBADI_QUAL_TYPE_HEADER gt,
2500: JTY_WEBADI_OTH_TERR_INTF jut
2501: where jut.header = L_header
2502: and jut.status is null
2503: and jut.USER_SEQUENCE = P_USER_SEQUENCE

Line 4765: from JTY_WEBADI_QUAL_TYPE_HEADER jq,

4761: jwot.LAST_UPDATE_DATE, jwot.LAST_UPDATED_BY,
4762: jwot.CREATION_DATE, jwot.CREATED_BY, jwot.LAST_UPDATE_LOGIN,
4763: sub.TERR_RSC_ID, jq.QUAL_TYPE_NAME ACCESS_TYPE,
4764: jwot.ORG_ID, sub.TRANS_ACCESS_CODE
4765: from JTY_WEBADI_QUAL_TYPE_HEADER jq,
4766: JTY_WEBADI_OTH_TERR_INTF jwot,
4767: (
4768: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4769: 1 qual_type_num, TERR_RSC_ACCESS_ID1 TERR_RSC_ACCESS_ID,

Line 4884: from JTY_WEBADI_QUAL_TYPE_HEADER jq,

4880: jwot.LAST_UPDATE_DATE, jwot.LAST_UPDATED_BY,
4881: jwot.CREATION_DATE, jwot.CREATED_BY, jwot.LAST_UPDATE_LOGIN,
4882: sub.TERR_RSC_ID, jq.QUAL_TYPE_NAME ACCESS_TYPE,
4883: jwot.ORG_ID, sub.TRANS_ACCESS_CODE
4884: from JTY_WEBADI_QUAL_TYPE_HEADER jq,
4885: JTY_WEBADI_OTH_TERR_INTF jwot,
4886: (
4887: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
4888: 1 qual_type_num, TERR_RSC_ACCESS_ID1 TERR_RSC_ACCESS_ID,