APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_TTY_TERR_GROUPS

Line 123: FROM jtf_tty_terr_groups a, jtf_terr_all b

119: CURSOR c_validate_tg(l_tg_name VARCHAR2) IS
120: SELECT a.terr_group_id,
121: a.active_from_date,
122: NVL( a.active_to_date, ADD_MONTHS(a.active_from_date,120) ) active_to_date
123: FROM jtf_tty_terr_groups a, jtf_terr_all b
124: WHERE a.parent_terr_id = b.terr_id
125: AND upper(a.terr_group_name) = upper(l_tg_name)
126: -- and b.org_id = FND_PROFILE.VALUE('ORG_ID')
127: AND a.self_service_type = 'NAMED_ACCOUNT'

Line 633: FROM jtf_tty_terr_groups a, jtf_terr_all b

629: CURSOR c_validate_tg(l_tg_name VARCHAR2) IS
630: SELECT a.terr_group_id, a.matching_rule_code,
631: a.active_from_date,
632: NVL( a.active_to_date, ADD_MONTHS(a.active_from_date,120) ) active_to_date
633: FROM jtf_tty_terr_groups a, jtf_terr_all b
634: WHERE a.parent_terr_id = b.terr_id
635: AND upper(a.terr_group_name) like upper(l_tg_name)
636: AND a.self_service_type = 'NAMED_ACCOUNT'
637: AND a.active_from_date <= sysdate

Line 1134: jtf_tty_terr_groups tg

1130: BEGIN
1131: SELECT 'VALID' INTO l_select
1132: FROM jtf_tty_terr_grp_accts tga,
1133: jtf_tty_named_acct_rsc nar,
1134: jtf_tty_terr_groups tg
1135: WHERE nar.terr_group_account_id = tga.terr_group_account_id
1136: AND nar.rsc_role_code = X_ROLE_CODE
1137: AND tga.terr_group_id = tg.terr_group_id
1138: AND sysdate >= tg.active_from_date

Line 3309: p_from_tg JTF_TTY_TERR_GROUPS.TERR_GROUP_NAME%TYPE;

3305: X_Msg_Data VARCHAR2(2000);
3306: l_matching_rule_code VARCHAR2(30);
3307:
3308:
3309: p_from_tg JTF_TTY_TERR_GROUPS.TERR_GROUP_NAME%TYPE;
3310: p_to_tg JTF_TTY_TERR_GROUPS.TERR_GROUP_NAME%TYPE;
3311: p_delete_flag_code VARCHAR2(1);
3312: l_excel_rscs_tbl EXCEL_SALESREP_RSC_TBLTYP;
3313: l_added_rscs_tbl SALESREP_RSC_TBL_TYPE;

Line 3310: p_to_tg JTF_TTY_TERR_GROUPS.TERR_GROUP_NAME%TYPE;

3306: l_matching_rule_code VARCHAR2(30);
3307:
3308:
3309: p_from_tg JTF_TTY_TERR_GROUPS.TERR_GROUP_NAME%TYPE;
3310: p_to_tg JTF_TTY_TERR_GROUPS.TERR_GROUP_NAME%TYPE;
3311: p_delete_flag_code VARCHAR2(1);
3312: l_excel_rscs_tbl EXCEL_SALESREP_RSC_TBLTYP;
3313: l_added_rscs_tbl SALESREP_RSC_TBL_TYPE;
3314: l_error_msg VARCHAR2(250);

Line 3351: from jtf_tty_terr_groups

3347: BEGIN
3348:
3349: Select matching_rule_code
3350: into l_matching_rule_code
3351: from jtf_tty_terr_groups
3352: where terr_group_name = p_to_tg;
3353:
3354: if((p_party_site_id is null or trim(p_party_site_id) is null ) and (trim(l_matching_rule_code) = '1' or trim(l_matching_rule_code) = '2' or trim(l_matching_rule_code) = '5'))
3355: then