APPS.CN_COMMISSION_CALC_PVT dependencies on CN_REPOSITORIES

Line 152: cn_repositories cr

148: jtf_rs_group_members mem,
149: jtf_rs_role_relations rr,
150: cn_interval_types cit,
151: cn_credit_types cci,
152: cn_repositories cr
153: where spa.salesrep_id = p_salesrep_id
154: and spa.start_date <= p_date
155: and nvl(spa.end_date, p_date) >= p_date
156: and jrs.salesrep_id = p_salesrep_id

Line 368: x_inc_plnr_disclaimer OUT NOCOPY cn_repositories.income_planner_disclaimer%TYPE,

364: Procedure calculate_Commission
365: (
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: x_inc_plnr_disclaimer OUT NOCOPY cn_repositories.income_planner_disclaimer%TYPE,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2
372: ) IS

Line 386: x_inc_plnr_disclaimer OUT NOCOPY cn_repositories.income_planner_disclaimer%TYPE,

382: (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_org_id IN NUMBER,
386: x_inc_plnr_disclaimer OUT NOCOPY cn_repositories.income_planner_disclaimer%TYPE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,
389: x_msg_data OUT NOCOPY VARCHAR2
390: ) IS

Line 407: FROM cn_period_types cpt,cn_repositories cr

403: , cr.set_of_books_id set_of_books_id
404: , cr.period_set_id period_set_id
405: , cr.period_type_id period_type_id
406: , cr.income_planner_disclaimer income_planner_disclaimer
407: FROM cn_period_types cpt,cn_repositories cr
408: WHERE cpt.period_type_id = cr.period_type_id
409: AND cpt.org_id = cr.org_id
410: AND cr.org_id = p_org_id;
411: