DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_SRP_PAY_GROUPS_ALL

Line 1479: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c

1475: BEGIN
1476:
1477: SELECT a.period_id
1478: INTO l_pay_period_id
1479: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c
1480: WHERE a.period_set_id = c.period_set_id
1481: AND a.org_id = p_org_id
1482: AND a.period_type_id = c.period_type_id
1483: AND b.pay_group_id = c.pay_group_id