APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_TTY_ALIGN_ACCTS

Line 46: from JTF_TTY_ALIGN_ACCTS ALAC

42: IS
43: -- Cursor to find all the named accounts associated with this alignment
44: cursor c_all_accounts IS
45: select ALAC.TERR_GROUP_ACCOUNT_ID
46: from JTF_TTY_ALIGN_ACCTS ALAC
47: where
48: ALAC.ALIGNMENT_ID = p_alignment_id;
49:
50: cursor c_get_invalid_accts( c_alignment_id NUMBER, c_user_id NUMBER) IS

Line 52: FROM jtf_tty_align_accts aa

48: ALAC.ALIGNMENT_ID = p_alignment_id;
49:
50: cursor c_get_invalid_accts( c_alignment_id NUMBER, c_user_id NUMBER) IS
51: SELECT 'Y'
52: FROM jtf_tty_align_accts aa
53: WHERE aa.alignment_id = c_alignment_id
54: AND aa.terr_group_account_id NOT IN
55: ( SELECT ga.terr_group_account_id
56: FROM jtf_tty_terr_grp_accts ga,

Line 77: , jtf_tty_align_accts alac

73: IS
74: SELECT 'Y'
75: FROM jtf_tty_pterr_accts alpa
76: , jtf_tty_align_pterr alpt
77: , jtf_tty_align_accts alac
78: , jtf_tty_terr_grp_accts tga
79: WHERE alpt.align_proposed_terr_id = alpa.align_proposed_terr_id
80: AND alpa.align_acct_id = alac.align_acct_id
81: AND alac.terr_group_account_id = tga.terr_group_account_id

Line 241: , JTF_TTY_ALIGN_ACCTS ALAC

237: , l_login_id
238: from
239: JTF_TTY_PTERR_ACCTS ALPA
240: , JTF_TTY_ALIGN_PTERR ALPT
241: , JTF_TTY_ALIGN_ACCTS ALAC
242: where
243: ALPA.ALIGN_PROPOSED_TERR_ID = ALPT.ALIGN_PROPOSED_TERR_ID
244: and ALAC.ALIGN_ACCT_ID = ALPA.ALIGN_ACCT_ID
245: and ALAC.TERR_GROUP_ACCOUNT_ID = account_rsc_table(j)