eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_API dependencies on CN_PAYRUNS

Line 2707: FROM cn_payruns

2703: ) RETURN VARCHAR2 IS
2704:
2705: CURSOR get_payrun_status IS
2706: SELECT status, payrun_id
2707: FROM cn_payruns
2708: WHERE payrun_id = p_payrun_id;
2709:
2710: l_status cn_payruns.status%TYPE;
2711: l_payrun_id cn_payruns.payrun_id%TYPE;

Line 2710: l_status cn_payruns.status%TYPE;

2706: SELECT status, payrun_id
2707: FROM cn_payruns
2708: WHERE payrun_id = p_payrun_id;
2709:
2710: l_status cn_payruns.status%TYPE;
2711: l_payrun_id cn_payruns.payrun_id%TYPE;
2712:
2713: BEGIN
2714: -- Initialize API return status to success

Line 2711: l_payrun_id cn_payruns.payrun_id%TYPE;

2707: FROM cn_payruns
2708: WHERE payrun_id = p_payrun_id;
2709:
2710: l_status cn_payruns.status%TYPE;
2711: l_payrun_id cn_payruns.payrun_id%TYPE;
2712:
2713: BEGIN
2714: -- Initialize API return status to success
2715: x_loading_status := p_loading_status ;

Line 2766: l_status cn_payruns.status%TYPE;

2762: FROM cn_salesreps
2763: WHERE salesrep_id = p_salesrep_id
2764: AND org_id = p_org_id;
2765:
2766: l_status cn_payruns.status%TYPE;
2767: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2768:
2769: BEGIN
2770:

Line 2820: l_status cn_payruns.status%TYPE;

2816: FROM cn_salesreps
2817: WHERE salesrep_id = p_salesrep_id
2818: AND org_id = p_org_id;
2819:
2820: l_status cn_payruns.status%TYPE;
2821: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2822:
2823: BEGIN
2824:

Line 3357: FROM cn_payruns p

3353: WHERE re1.user_id = l_user_id --129941
3354: AND (pr.period_id, pr.org_id) =
3355: (SELECT p.pay_period_id,
3356: p.org_id
3357: FROM cn_payruns p
3358: WHERE p.payrun_id = l_payrun_id ) -- 852986
3359: AND u1.usage = 'COMP_PAYMENT'
3360: AND ((m1.start_date_active <= pr.end_date) AND
3361: (pr.start_date <= nvl(m1.end_date_active, pr.start_date)))

Line 3426: FROM cn_payruns p

3422: WHERE re1.user_id = l_user_id --129941
3423: AND (pr.period_id, pr.org_id) =
3424: (SELECT p.pay_period_id,
3425: p.org_id
3426: FROM cn_payruns p
3427: WHERE p.payrun_id = l_payrun_id ) -- 852986
3428: AND u1.usage = 'COMP_PAYMENT'
3429: AND ((m1.start_date_active <= pr.end_date) AND
3430: (pr.start_date <= nvl(m1.end_date_active, pr.start_date)))