DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_TTY_ALIGN_PTERR

Line 76: , jtf_tty_align_pterr alpt

72: cursor c_get_invalid_roles (c_alignment_id NUMBER )
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

Line 240: , JTF_TTY_ALIGN_PTERR ALPT

236: , sysdate
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