APPS.CN_WKSHT_GET_PUB dependencies on FND_USER

Line 83: fnd_user u

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
87: and w.payrun_id = p.payrun_id

Line 145: l_user_name fnd_user.user_name%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;
149: l_current_earnings NUMBER;