APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_SRCH_MY_RESOURCES_V

Line 406: ' jtf_tty_srch_my_resources_v repdn '||

402: ' ) '||
403: ' and ga.terr_group_account_id IN '||
404: ' ( select /*+ NO_MERGE */ narsc.terr_group_account_id '||
405: ' from jtf_tty_named_acct_rsc narsc, '||
406: ' jtf_tty_srch_my_resources_v repdn '||
407: ' where narsc.resource_id = repdn.resource_id '||
408: ' and narsc.rsc_group_id = repdn.group_id '||
409: ' and repdn.current_user_id = :p_userid '||
410: ' ) '||

Line 1031: jtf_tty_srch_my_resources_v repdn

1027: and ga.terr_group_account_id IN
1028: ( select /*+ NO_MERGE */
1029: narsc.terr_group_account_id
1030: from jtf_tty_named_acct_rsc narsc,
1031: jtf_tty_srch_my_resources_v repdn
1032: where narsc.resource_id = repdn.resource_id
1033: and narsc.rsc_group_id = repdn.group_id
1034: and repdn.current_user_id = c_user_id
1035: );

Line 1046: from jtf_tty_srch_my_resources_v mydir

1042: where narsc.terr_group_account_id = c_tg_acct_id
1043: and narsc.rsc_resource_type = 'RS_EMPLOYEE'
1044: and (narsc.resource_id, narsc.rsc_group_id, narsc.rsc_role_code ) IN
1045: ( select /*+ NO_MERGE */ mydir.resource_id, mydir.group_id, mydir.role_code
1046: from jtf_tty_srch_my_resources_v mydir
1047: where mydir.current_user_id = c_user_id );
1048:
1049:
1050: CURSOR c_direct_for_tg_account(c_tg_acct_id VARCHAR2, c_user_id NUMBER) IS

Line 1490: jtf_tty_srch_my_resources_v repdn

1486: )
1487: and ga.terr_group_account_id IN
1488: ( select /*+ NO_MERGE */ narsc.terr_group_account_id
1489: from jtf_tty_named_acct_rsc narsc,
1490: jtf_tty_srch_my_resources_v repdn
1491: where narsc.resource_id = repdn.resource_id
1492: and narsc.rsc_group_id = repdn.group_id
1493: and repdn.current_user_id = l_user_id
1494: )