[Home] [Help]
217: CURSOR l_cur(l_srp_id IN NUMBER,
218: l_s_prd_id IN NUMBER,
219: l_e_prd_id IN NUMBER) IS
220: SELECT a1.period_id, a1.start_date, a1.end_date
221: FROM cn_period_statuses a1, cn_repositories r
222: WHERE (a1.period_id BETWEEN l_s_prd_id AND l_e_prd_id)
223: AND a1.period_status in ('O', 'F')
224: AND a1.period_set_id = r.period_set_id
225: AND a1.period_type_id = r.period_type_id
1013: and tm.delete_flag = 'N'
1014: and tu.team_id = tm.team_id
1015: and tu.usage = 'SALES_COMP'
1016: and sr.resource_id = tm.team_resource_id
1017: and (sr.org_id is null or sr.org_id = (select org_id from cn_repositories))
1018: and rr.role_resource_id(+) = tm.team_member_id
1019: and rr.delete_flag(+) = 'N'
1020: and rb.role_id(+) = rr.role_id
1021: and rb.role_type_code(+) = 'SALES_COMP'
1871: and tm.delete_flag = 'N'
1872: and tu.team_id = tm.team_id
1873: and tu.usage = 'SALES_COMP'
1874: and sr.resource_id = tm.team_resource_id
1875: and (sr.org_id is null or sr.org_id = (select org_id from cn_repositories))
1876: and rr.role_resource_id(+) = tm.team_member_id
1877: and rr.delete_flag(+) = 'N'
1878: and rb.role_id(+) = rr.role_id
1879: and rb.role_type_code(+) = 'SALES_COMP'
2213: and tm.delete_flag = 'N'
2214: and tu.team_id = tm.team_id
2215: and tu.usage = 'SALES_COMP'
2216: and sr.resource_id = tm.team_resource_id
2217: and (sr.org_id is null or sr.org_id = (select org_id from cn_repositories))
2218: and rr.role_resource_id(+) = tm.team_member_id
2219: and rr.delete_flag(+) = 'N'
2220: and rb.role_id(+) = rr.role_id
2221: and rb.role_type_code(+) = 'SALES_COMP'