APPS.CN_WKSHT_GET_PUB dependencies on CN_LOOKUPS

Line 82: cn_lookups lk,

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
86: and w.worksheet_status = lk.lookup_code

Line 144: l_worksheet_status cn_lookups.meaning%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;
148: l_diff2 NUMBER := 0;

Line 160: l_worksheet_status_code cn_lookups.lookup_code%TYPE;

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;
163: c_worksheet_status cn_payment_worksheets.worksheet_status%TYPE;
164: c_analyst_id NUMBER;