APPS.CN_WKSHT_GET_PUB dependencies on CN_SALESREPS

Line 6: salesrep_id cn_salesreps.salesrep_id%TYPE,

2: -- $Header: cnpwkgts.pls 115.20 2003/07/24 02:54:17 achung ship $
3:
4: TYPE Wksht_rec IS RECORD
5: ( payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
6: salesrep_id cn_salesreps.salesrep_id%TYPE,
7: salesrep_name cn_salesreps.name%TYPE,
8: resource_id cn_salesreps.resource_id%TYPE,
9: employee_number cn_salesreps.employee_number%TYPE,
10: current_earnings NUMBER,

Line 7: salesrep_name cn_salesreps.name%TYPE,

3:
4: TYPE Wksht_rec IS RECORD
5: ( payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
6: salesrep_id cn_salesreps.salesrep_id%TYPE,
7: salesrep_name cn_salesreps.name%TYPE,
8: resource_id cn_salesreps.resource_id%TYPE,
9: employee_number cn_salesreps.employee_number%TYPE,
10: current_earnings NUMBER,
11: pmt_amount_earnings NUMBER,

Line 8: resource_id cn_salesreps.resource_id%TYPE,

4: TYPE Wksht_rec IS RECORD
5: ( payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
6: salesrep_id cn_salesreps.salesrep_id%TYPE,
7: salesrep_name cn_salesreps.name%TYPE,
8: resource_id cn_salesreps.resource_id%TYPE,
9: employee_number cn_salesreps.employee_number%TYPE,
10: current_earnings NUMBER,
11: pmt_amount_earnings NUMBER,
12: pmt_amount_diff NUMBER,

Line 9: employee_number cn_salesreps.employee_number%TYPE,

5: ( payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
6: salesrep_id cn_salesreps.salesrep_id%TYPE,
7: salesrep_name cn_salesreps.name%TYPE,
8: resource_id cn_salesreps.resource_id%TYPE,
9: employee_number cn_salesreps.employee_number%TYPE,
10: current_earnings NUMBER,
11: pmt_amount_earnings NUMBER,
12: pmt_amount_diff NUMBER,
13: pmt_amount_adj NUMBER,

Line 19: Analyst_name cn_salesreps.assigned_to_user_name%TYPE,

15: Pmt_amount_total NUMBER,
16: held_amount NUMBER,
17: worksheet_status cn_lookups.meaning%TYPE,
18: worksheet_status_code cn_lookups.lookup_code%TYPE,
19: Analyst_name cn_salesreps.assigned_to_user_name%TYPE,
20: object_version_number NUMBER,
21: view_notes VARCHAR2(1),
22: view_ced VARCHAR2(1),
23: status_by fnd_user.user_name%TYPE,

Line 24: cost_center cn_salesreps.cost_center%TYPE,

20: object_version_number NUMBER,
21: view_notes VARCHAR2(1),
22: view_ced VARCHAR2(1),
23: status_by fnd_user.user_name%TYPE,
24: cost_center cn_salesreps.cost_center%TYPE,
25: charge_to_cost_center cn_salesreps.charge_to_cost_center%TYPE,
26: notes cn_lookups.meaning%TYPE
27: );
28:

Line 25: charge_to_cost_center cn_salesreps.charge_to_cost_center%TYPE,

21: view_notes VARCHAR2(1),
22: view_ced VARCHAR2(1),
23: status_by fnd_user.user_name%TYPE,
24: cost_center cn_salesreps.cost_center%TYPE,
25: charge_to_cost_center cn_salesreps.charge_to_cost_center%TYPE,
26: notes cn_lookups.meaning%TYPE
27: );
28:
29: TYPE wksht_tbl IS TABLE OF wksht_rec INDEX BY BINARY_INTEGER;