DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_TTY_PTERR_ACCTS

Line 75: FROM jtf_tty_pterr_accts alpa

71:
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

Line 239: JTF_TTY_PTERR_ACCTS ALPA

235: , p_user_id
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