DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_RS_ROLES_VL

Line 183: -- jtf_rs_roles_vl rol

179: select ap.rsc_role_code role_code, count(ap.rsc_role_code) num
180: from JTF_TTY_ALIGN_ACCTS aa,
181: JTF_TTY_PTERR_ACCTS pa,
182: JTF_TTY_ALIGN_PTERR ap
183: -- jtf_rs_roles_vl rol
184: where
185: aa.alignment_id = p_align_id
186: and aa.align_acct_id = pa.align_acct_id
187: and pa.align_proposed_terr_id= ap.align_proposed_terr_id

Line 279: jtf_rs_roles_vl rol

275: JTF_TTY_PTERR_ACCTS pa,
276: JTF_TTY_ALIGN_PTERR ap,
277: jtf_rs_resource_extns_vl rsc,
278: jtf_rs_groups_vl grp,
279: jtf_rs_roles_vl rol
280: where aa.terr_group_account_id = tgaid
281: and aa.alignment_id = align_id
282: and aa.align_acct_id = pa.align_acct_id
283: and pa.align_proposed_terr_id= ap.align_proposed_terr_id