[Home] [Help]
75: w.worksheet_status,
76: w.object_version_number,
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
132:
133: l_where9 Varchar2(5000) := ') or ( s.assigned_to_user_id IS NULL ) ';
134: l_where11 Varchar2(5000) := ') ';
135: l_wksht_rec wksht_rec;
136: l_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE;
137: l_salesrep_name cn_salesreps.name%TYPE;
138: l_employee_number cn_salesreps.employee_number%TYPE;
139: l_cost_center cn_salesreps.cost_center%TYPE;
140: l_charge_to_cost_center cn_salesreps.charge_to_cost_center%TYPE;
159: l_object_version_number NUMBER;
160: l_worksheet_status_code cn_lookups.lookup_code%TYPE;
161: c_salesrep_name cn_salesreps.name%TYPE;
162: c_employee_number cn_salesreps.employee_number%TYPE;
163: c_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
164: c_analyst_id NUMBER;
165: c_analyst_name cn_salesreps.assigned_to_user_name%TYPE;
166: l_analyst_flag VARCHAR2(01) := 'N';
167: l_view_ced VARCHAR2(1);
186: -- cursor to check if thenote exist
187: CURSOR view_notes_cur (l_payment_worksheet_id cn_worksheet_qg_dtls.payment_worksheet_id%TYPE) IS
188: SELECT 'Y' FROM dual WHERE exists
189: (SELECT 1
190: FROM JTF_NOTES_B WHERE SOURCE_OBJECT_CODE = 'CN_PAYMENT_WORKSHEETS'
191: AND SOURCE_OBJECT_ID = l_payment_worksheet_id
192: );
193:
194: FUNCTION Convert_Amount(l_from_amount NUMBER, l_date Date, c_org_id NUMBER)
243: AND (pay.status <> 'PAID' OR
244: (pay.status = 'PAID'
245: AND exists
246: (SELECT 1
247: FROM cn_worksheet_qg_dtls dtls, cn_payment_worksheets wrk
248: WHERE dtls.payment_worksheet_id = wrk.payment_worksheet_id
249: AND wrk.payrun_id = pay.payrun_id
250: AND wrk.salesrep_id = dtls.salesrep_id)
251: ));