APPS.CN_PAY_GROUP_DTLS_PVT dependencies on CN_PERIOD_STATUSES

Line 29: from cn_pay_groups cpg, cn_period_statuses cps, cn_period_sets cs

25: l_counter NUMBER;
26:
27: CURSOR l_pay_group_dtls_cr IS
28: select cpg.pay_group_id, cpg.name, cs.period_set_name, cpg.period_type, cps.period_name, cps.period_year, cps.quarter_num, cps.start_date, cps.end_date
29: from cn_pay_groups cpg, cn_period_statuses cps, cn_period_sets cs
30: where (cpg.period_set_id = cps.period_set_id) and
31: (cpg.period_type_id = cps.period_type_id) and
32: (cpg.start_date <= cps.start_date) and
33: ( nvl(cpg.end_date, cps.end_date) >= cps.end_date) and