APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_SRP_PAYEE_ASSIGNS

Line 1957: from cn_srp_roles sr, cn_srp_payee_assigns spa

1953: IF l_role_resource_type = 'RS_INDIVIDUAL' THEN
1954: -- if deleting a payee role, make sure no payee assigned over that period
1955: if l_role_id = G_PAYEE_ROLE then
1956: select count(1) into l_count
1957: from cn_srp_roles sr, cn_srp_payee_assigns spa
1958: where sr.srp_role_id = p_role_relate_id
1959: and spa.payee_id = sr.salesrep_id
1960: and sr.start_date <= nvl(spa.end_date, sr.start_date)
1961: and spa.start_date <= nvl(sr.end_date, spa.start_date);

Line 2168: select salesrep_id, start_date, end_date from cn_srp_payee_assigns

2164: --variable added for bug 6914823
2165: l_res_start_date DATE;
2166:
2167: CURSOR payee_assign_date_curs(l_payee_id NUMBER) IS
2168: select salesrep_id, start_date, end_date from cn_srp_payee_assigns
2169: where payee_id = l_payee_id;
2170:
2171: l_max_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
2172: --clku, team member rs role mark event