[Home] [Help]
121: select start_date into l_year_start_date from cn_period_statuses
122: where period_id = p_period_id - mod(p_period_id, 1000) + 1;
123: */
124:
125: select min(start_date) into l_year_start_date from cn_period_statuses cps,cn_repositories cr
126: where cps.period_year=l_year and cr.period_set_id=cps.period_set_id
127: and cr.period_type_id=cps.period_type_id and cr.org_id=cps.org_id
128: and cr.org_id=p_org_id;
129: /**
415: nvl(inv.credit,0) credit,
416: nvl(inv.earnings,0) earnings,
417: nvl(inv.target,0) target,
418: nvl(inv.itd_target,0) itd_target
419: from cn_period_statuses ps, cn_repositories r, cn_period_statuses ps2,
420: (SELECT ps.period_id period_id,
421: nvl(sum(cspq.perf_achieved_ptd),0) credit,
422: nvl(sum(cspq.commission_payed_ptd),0) earnings,
423: nvl(sum(cspq.target_amount),0) target,
424: nvl(sum(cspq.itd_target),0) itd_target
425: FROM cn_srp_period_quotas cspq,
426: cn_quotas_all quota,
427: cn_period_statuses ps,
428: cn_repositories r,
429: cn_period_statuses ps2
430: WHERE cspq.srp_plan_assign_id = p_srp_plan_assign_id
431: AND cspq.quota_id = quota.quota_id
432: AND quota.credit_type_id = p_credit_type_id
1208: FUNCTION get_conversion_type(p_org_id IN NUMBER)
1209: RETURN VARCHAR2 IS
1210: l_profile_value VARCHAR2(100);
1211: cursor prof_cursor(a_org_id NUMBER) is
1212: SELECT CN_CONVERSION_TYPE FROM CN_REPOSITORIES WHERE ORG_ID=a_org_id;
1213: d prof_cursor%rowtype;
1214: BEGIN
1215: open prof_cursor(p_org_id);
1216: fetch prof_cursor into d;