DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_RS_SALESREPS

Line 2838: p_Salesrep_id IN cn_rs_salesreps.salesrep_id%TYPE,

2834: --| ---------------------------------------------------------------------+
2835: FUNCTION Get_pay_Element_ID
2836: (
2837: p_quota_id IN NUMBER,
2838: p_Salesrep_id IN cn_rs_salesreps.salesrep_id%TYPE,
2839: p_org_id IN NUMBER,
2840: p_date IN DATE
2841: ) RETURN NUMBER IS
2842:

Line 2847: cn_rs_salesreps s

2843: -- Bug 2875120 3/27/03
2844: CURSOR /*+ ordered */ get_pay_element IS
2845: SELECT pay_element_type_id
2846: FROM cn_quota_pay_elements p,
2847: cn_rs_salesreps s
2848: WHERE p.quota_id = p_quota_id
2849: AND p_date between p.start_date and p.end_date
2850: AND s.salesrep_id = p_salesrep_id
2851: AND s.org_id = p_org_id