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_WKSHT_GET_PUB dependencies on CN_SALESREPS

Line 80: cn_salesreps s,

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
84: where s.salesrep_id = w.salesrep_id

Line 137: l_salesrep_name cn_salesreps.name%TYPE;

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;
141: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

Line 138: l_employee_number cn_salesreps.employee_number%TYPE;

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;
141: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
142: l_resource_id cn_salesreps.resource_id%TYPE;

Line 139: l_cost_center cn_salesreps.cost_center%TYPE;

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;
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;

Line 140: l_charge_to_cost_center cn_salesreps.charge_to_cost_center%TYPE;

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;
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;

Line 141: l_salesrep_id cn_salesreps.salesrep_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;
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;

Line 142: l_resource_id cn_salesreps.resource_id%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;
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;

Line 158: l_analyst_name cn_salesreps.assigned_to_user_name%TYPE;

154: l_pmt_amount_recovery NUMBER;
155: l_pmt_amount_total NUMBER;
156: l_held_amount NUMBER;
157:
158: l_analyst_name cn_salesreps.assigned_to_user_name%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;

Line 161: c_salesrep_name cn_salesreps.name%TYPE;

157:
158: l_analyst_name cn_salesreps.assigned_to_user_name%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;

Line 162: c_employee_number cn_salesreps.employee_number%TYPE;

158: l_analyst_name cn_salesreps.assigned_to_user_name%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';

Line 165: c_analyst_name cn_salesreps.assigned_to_user_name%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);
168: l_view_notes VARCHAR2(1);
169: l_b6 Varchar2(100);