Line 1501: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c
1497: BEGIN
1498:
1499: SELECT a.period_id
1500: INTO l_pay_period_id 1501: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c 1502: WHERE a.period_set_id = c.period_set_id
1503: AND a.org_id = p_org_id
1504: AND a.period_type_id = c.period_type_id
1505: AND b.pay_group_id = c.pay_group_id