DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_SRP_PAY_GROUPS_ALL

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