DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_RS_SALESREPS

Line 2860: p_Salesrep_id IN cn_rs_salesreps.salesrep_id%TYPE,

2856: --| ---------------------------------------------------------------------+
2857: FUNCTION Get_pay_Element_ID
2858: (
2859: p_quota_id IN NUMBER,
2860: p_Salesrep_id IN cn_rs_salesreps.salesrep_id%TYPE,
2861: p_org_id IN NUMBER,
2862: p_date IN DATE
2863: ) RETURN NUMBER IS
2864:

Line 2869: cn_rs_salesreps s

2865: -- Bug 2875120 3/27/03
2866: CURSOR /*+ ordered */ get_pay_element IS
2867: SELECT pay_element_type_id
2868: FROM cn_quota_pay_elements p,
2869: cn_rs_salesreps s
2870: WHERE p.quota_id = p_quota_id
2871: AND p_date between p.start_date and p.end_date
2872: AND s.salesrep_id = p_salesrep_id
2873: AND s.org_id = p_org_id