APPS.CN_PAY_GROUP_DTLS_PVT dependencies on CN_PERIOD_SETS

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

Line 173: cn_period_sets cs

169: nvl(cspg.end_date, cpg.end_date) h
170: from cn_pay_groups cpg,
171: cn_salesreps csr,
172: cn_srp_pay_groups cspg,
173: cn_period_sets cs
174: where (cpg.pay_group_id = cspg.pay_group_id) and
175: (csr.salesrep_id = cspg.salesrep_id) and
176: (cpg.period_set_id = cs.period_set_id) and
177: (cpg.pay_group_id = p_pay_group_id);

Line 315: cn_period_sets cs

311: cspg.end_date h
312: from cn_pay_groups cpg,
313: cn_roles csr,
314: cn_role_pay_groups cspg,
315: cn_period_sets cs
316: where (cpg.pay_group_id = cspg.pay_group_id) and
317: (csr.role_id = cspg.role_id) and
318: (cpg.pay_group_id = p_pay_group_id);
319: