APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_TERR_GROUPS

Line 378: ' jtf_tty_terr_groups ttygrp '||

374: ' from hz_parties hzp, '||
375: ' jtf_tty_named_accts na, '||
376: ' jtf_tty_terr_grp_accts ga, '||
377: ' fnd_lookups lkp, '||
378: ' jtf_tty_terr_groups ttygrp '||
379: ' , ( /* Global Ultimate */ ' ||
380: ' SELECT min(gup.party_name) GU_NAME ' ||
381: ' , min(gup.duns_number_c) GU_DUNS ' ||
382: ' , hzr.object_id GU_OBJECT_ID ' ||

Line 1020: jtf_tty_terr_groups ttygrp

1016:
1017: CURSOR c_all_tg_accounts( c_user_id NUMBER ) IS
1018: select ga.terr_group_account_id gaid
1019: from jtf_tty_terr_grp_accts ga,
1020: jtf_tty_terr_groups ttygrp
1021: where ttygrp.terr_group_id = ga.terr_group_id
1022: and ttygrp.active_from_date <= sysdate
1023: and ( ttygrp.active_to_date is null
1024: or

Line 1480: jtf_tty_terr_groups ttygrp

1476: where alignment_id = l_alignment_id
1477: and terr_group_account_id NOT IN
1478: ( select ga.terr_group_account_id
1479: from jtf_tty_terr_grp_accts ga,
1480: jtf_tty_terr_groups ttygrp
1481: where ttygrp.terr_group_id = ga.terr_group_id
1482: and ttygrp.active_from_date <= sysdate
1483: and ( ttygrp.active_to_date is null
1484: or