APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_PERIOD_STATUSES_ALL

Line 1070: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

1066:
1067: -- check if the payee has any worksheet
1068: SELECT count(*)
1069: into l_ws_count
1070: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
1071: cn_payruns_all prun
1072: WHERE w.salesrep_id = p_paygroup_assign_rec.salesrep_id
1073: AND w.org_id = p_paygroup_assign_rec.org_id
1074: AND prun.pay_period_id = prd.period_id

Line 1443: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

1439:
1440: -- check if the payee has any worksheet
1441: SELECT count(*)
1442: into l_ws_count
1443: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
1444: cn_payruns_all prun
1445: WHERE w.salesrep_id = p_paygroup_assign_rec.salesrep_id
1446: AND w.org_id = p_paygroup_assign_rec.org_id
1447: AND prun.pay_period_id = prd.period_id

Line 1498: cn_period_statuses_all prd, cn_payruns_all prun

1494: p_paygroup_assign_rec.assignment_start_date AND
1495: nvl(p_paygroup_assign_rec.assignment_end_date,l_null_date))
1496: AND NOT EXISTS
1497: (SELECT 1 FROM cn_payment_worksheets_all W,
1498: cn_period_statuses_all prd, cn_payruns_all prun
1499: WHERE w.salesrep_id = p_paygroup_assign_rec.salesrep_id
1500: AND w.org_id = p_paygroup_assign_rec.org_id
1501: AND prun.pay_period_id = prd.period_id
1502: AND prun.payrun_id = w.payrun_id

Line 1916: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

1912: RAISE FND_API.G_EXC_ERROR;
1913: END IF;
1914: SELECT count(*)
1915: into l_count
1916: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
1917: cn_payruns_all prun
1918: WHERE w.salesrep_id = l_salesrep_id
1919: AND w.org_id = l_org_id
1920: AND prun.pay_period_id = prd.period_id