APPS.JTF_TTY_NA_TERRGP dependencies on JTF_RS_RESOURCE_EXTNS

Line 1668: JTF_RS_RESOURCE_EXTNS rs

1664:
1665: CURSOR ALL_OWNER_USERS_C
1666: IS SELECT DISTINCT rs.user_id, tgo.rsc_group_id
1667: FROM JTF_TTY_TERR_GRP_OWNERS tgo,
1668: JTF_RS_RESOURCE_EXTNS rs
1669: WHERE rs.resource_id = tgo.resource_id;
1670:
1671: CURSOR all_managers_c
1672: IS SELECT mdv.resource_id,

Line 1735: jtf_rs_resource_extns rs,

1731: jtf_tty_named_accts na,
1732: jtf_tty_terr_grp_accts ga,
1733: jtf_tty_my_resources_v repdn,
1734: jtf_tty_named_acct_rsc narsc,
1735: jtf_rs_resource_extns rs,
1736: jtf_rs_group_members mem,
1737: jtf_tty_terr_groups ttygrp
1738: WHERE na.named_account_id = ga.named_account_id
1739: AND ga.terr_group_account_id = narsc.terr_group_account_id

Line 1759: jtf_rs_resource_extns rs,

1755: jtf_tty_named_accts na,
1756: jtf_tty_terr_grp_accts ga,
1757: jtf_tty_my_resources_v repdn,
1758: jtf_tty_named_acct_rsc narsc,
1759: jtf_rs_resource_extns rs,
1760: jtf_rs_group_members mem,
1761: jtf_tty_terr_groups ttygrp
1762: WHERE na.named_account_id = ga.named_account_id
1763: AND ga.terr_group_account_id = narsc.terr_group_account_id