APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTY_WEBADI_QUAL_TYPE_HEADER

Line 4940: from JTY_WEBADI_QUAL_TYPE_HEADER gt,

4936: LAST_UPDATE_LOGIN,
4937: TERR_ID,
4938: QUAL_TYPE_ID QUAL_TYPE_USG_ID,
4939: ORG_ID
4940: from JTY_WEBADI_QUAL_TYPE_HEADER gt,
4941: JTY_WEBADI_OTH_TERR_INTF jut
4942: where jut.header = L_header
4943: and jut.status is null
4944: and jut.USER_SEQUENCE = P_USER_SEQUENCE

Line 10672: from JTY_WEBADI_QUAL_TYPE_HEADER jq,

10668: jwot.LAST_UPDATE_DATE, jwot.LAST_UPDATED_BY,
10669: jwot.CREATION_DATE, jwot.CREATED_BY, jwot.LAST_UPDATE_LOGIN,
10670: sub.TERR_RSC_ID, jq.QUAL_TYPE_NAME ACCESS_TYPE,
10671: jwot.ORG_ID, sub.TRANS_ACCESS_CODE
10672: from JTY_WEBADI_QUAL_TYPE_HEADER jq,
10673: JTY_WEBADI_OTH_TERR_INTF jwot,
10674: (
10675: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
10676: 1 qual_type_num, TERR_RSC_ACCESS_ID1 TERR_RSC_ACCESS_ID,

Line 10791: from JTY_WEBADI_QUAL_TYPE_HEADER jq,

10787: jwot.LAST_UPDATE_DATE, jwot.LAST_UPDATED_BY,
10788: jwot.CREATION_DATE, jwot.CREATED_BY, jwot.LAST_UPDATE_LOGIN,
10789: sub.TERR_RSC_ID, jq.QUAL_TYPE_NAME ACCESS_TYPE,
10790: jwot.ORG_ID, sub.TRANS_ACCESS_CODE
10791: from JTY_WEBADI_QUAL_TYPE_HEADER jq,
10792: JTY_WEBADI_OTH_TERR_INTF jwot,
10793: (
10794: select user_sequence, TERR_RSC_ID, lay_seq_num, header,
10795: 1 qual_type_num, TERR_RSC_ACCESS_ID1 TERR_RSC_ACCESS_ID,