APPS.CN_WKSHT_GET_PUB dependencies on CN_PAYRUNS

Line 81: cn_payruns p,

77: p.pay_date,
78: p.org_id
79: from cn_payment_worksheets w,
80: cn_salesreps s,
81: cn_payruns p,
82: cn_lookups lk,
83: fnd_user u
84: where s.salesrep_id = w.salesrep_id
85: and w.org_id = s.org_id

Line 112: = ( select pay_period_id from cn_payruns where payrun_id = :B8)

108: cn_period_statuses pr, jtf_rs_group_usages u1,
109: jtf_rs_rep_managers m1
110: WHERE re1.user_id = :B7
111: AND pr.period_id
112: = ( select pay_period_id from cn_payruns where payrun_id = :B8)
113: AND u1.usage = ''COMP_PAYMENT''
114: AND ((m1.start_date_active <= pr.end_date) AND
115: (pr.start_date <= Nvl(m1.end_date_active,pr.start_date)))
116: AND u1.group_id = m1.group_id

Line 143: l_status cn_payruns.status%TYPE;

139: l_cost_center cn_salesreps.cost_center%TYPE;
140: l_charge_to_cost_center cn_salesreps.charge_to_cost_center%TYPE;
141: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
142: l_resource_id cn_salesreps.resource_id%TYPE;
143: l_status cn_payruns.status%TYPE;
144: l_worksheet_status cn_lookups.meaning%TYPE;
145: l_user_name fnd_user.user_name%TYPE;
146: l_pay_date DATE;
147: l_diff1 NUMBER := 0;

Line 178: FROM cn_payruns WHERE payrun_id = p_payrun_id;

174: l_org_id NUMBER ;
175:
176: CURSOR get_payrun_curs IS
177: SELECT status
178: FROM cn_payruns WHERE payrun_id = p_payrun_id;
179:
180: -- cursor to check if the worksheet is pre-1158 release.
181: CURSOR view_ced_cur (l_payment_worksheet_id cn_worksheet_qg_dtls.payment_worksheet_id%TYPE) IS
182: SELECT 'Y' FROM dual WHERE exists

Line 241: FROM cn_payruns pay

237: -- Check if this payrun is new payrun created after 11.5.8 upgrade
238: BEGIN
239: l_tmp := 0 ;
240: SELECT 1 INTO l_tmp
241: FROM cn_payruns pay
242: WHERE pay.payrun_id = p_payrun_id
243: AND (pay.status <> 'PAID' OR
244: (pay.status = 'PAID'
245: AND exists

Line 272: FROM cn_payruns

268: jtf_rs_rep_managers m1
269: WHERE re1.user_id = fnd_global.user_id
270: AND (pr.period_id, pr.org_id) = (
271: SELECT pay_period_id, org_id
272: FROM cn_payruns
273: WHERE payrun_id = p_payrun_id)
274: AND u1.usage = 'COMP_PAYMENT'
275: AND ((m1.start_date_active <= pr.end_date) AND
276: (pr.start_date <= Nvl(m1.end_date_active,pr.start_date)))