APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_PERIOD_STATUSES

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 1122: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun

1118: OR
1119: ((l_old_assignment_end_date IS NULL) AND
1120: (p_paygroup_assign_rec.assignment_end_date IS NOT NULL)) ) THEN
1121: SELECT count(1) INTO l_dummy
1122: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun
1123: WHERE w.salesrep_id = p_paygroup_assign_rec.salesrep_id
1124: AND w.org_id = p_paygroup_assign_rec.org_id
1125: AND prun.pay_period_id = prd.period_id
1126: AND prd.org_id = p_paygroup_assign_rec.org_id

Line 1148: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun

1144: -- date can be extend or shrink.
1145:
1146: IF l_old_assignment_start_date < p_paygroup_assign_rec.assignment_start_date THEN
1147: SELECT count(1) INTO l_dummy
1148: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun
1149: WHERE w.salesrep_id = p_paygroup_assign_rec.salesrep_id
1150: AND w.org_id = p_paygroup_assign_rec.org_id
1151: AND prun.pay_period_id = prd.period_id
1152: AND prd.org_id = p_paygroup_assign_rec.org_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