APPS.CN_API dependencies on CN_PAYRUNS

Line 2685: FROM cn_payruns

2681: ) RETURN VARCHAR2 IS
2682:
2683: CURSOR get_payrun_status IS
2684: SELECT status, payrun_id
2685: FROM cn_payruns
2686: WHERE payrun_id = p_payrun_id;
2687:
2688: l_status cn_payruns.status%TYPE;
2689: l_payrun_id cn_payruns.payrun_id%TYPE;

Line 2688: l_status cn_payruns.status%TYPE;

2684: SELECT status, payrun_id
2685: FROM cn_payruns
2686: WHERE payrun_id = p_payrun_id;
2687:
2688: l_status cn_payruns.status%TYPE;
2689: l_payrun_id cn_payruns.payrun_id%TYPE;
2690:
2691: BEGIN
2692: -- Initialize API return status to success

Line 2689: l_payrun_id cn_payruns.payrun_id%TYPE;

2685: FROM cn_payruns
2686: WHERE payrun_id = p_payrun_id;
2687:
2688: l_status cn_payruns.status%TYPE;
2689: l_payrun_id cn_payruns.payrun_id%TYPE;
2690:
2691: BEGIN
2692: -- Initialize API return status to success
2693: x_loading_status := p_loading_status ;

Line 2744: l_status cn_payruns.status%TYPE;

2740: FROM cn_salesreps
2741: WHERE salesrep_id = p_salesrep_id
2742: AND org_id = p_org_id;
2743:
2744: l_status cn_payruns.status%TYPE;
2745: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2746:
2747: BEGIN
2748:

Line 2798: l_status cn_payruns.status%TYPE;

2794: FROM cn_salesreps
2795: WHERE salesrep_id = p_salesrep_id
2796: AND org_id = p_org_id;
2797:
2798: l_status cn_payruns.status%TYPE;
2799: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2800:
2801: BEGIN
2802: