APPS.CN_PAYMENT_SECURITY_PVT dependencies on CN_SALESREPS

Line 1057: l_assigned_to_user_id cn_salesreps.assigned_to_user_id%TYPE := NULL;

1053: l_period_id cn_period_statuses.period_id%TYPE;
1054: l_worksheet_rec cn_payment_worksheets%ROWTYPE;
1055: l_payrun_status cn_payruns.status%TYPE;
1056: l_pay_period_id cn_payruns.pay_period_id%TYPE;
1057: l_assigned_to_user_id cn_salesreps.assigned_to_user_id%TYPE := NULL;
1058: l_tmp NUMBER;
1059: l_org_id NUMBER;
1060:
1061: CURSOR c (

Line 1122: cn_salesreps s

1118: l_assigned_to_user_id,
1119: l_org_id
1120: FROM cn_payment_worksheets wk,
1121: cn_payruns pay,
1122: cn_salesreps s
1123: WHERE wk.payment_worksheet_id = p_worksheet_id
1124: AND pay.payrun_id = wk.payrun_id
1125: AND s.salesrep_id = wk.salesrep_id
1126: --R12