APPS.CN_PAY_GROUP_DTLS_PVT dependencies on CN_PAY_GROUPS

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 170: from cn_pay_groups cpg,

166: csr.name e,
167: csr.employee_number f,
168: cspg.start_date g,
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

Line 312: from cn_pay_groups cpg,

308: csr.name e,
309: csr.role_id f,
310: cspg.start_date g,
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

Line 385: -- SELECT name INTO x_pay_group_roles(l_counter).name FROM CN_PAY_GROUPS WHERE PAY_GROUP_ID= p_pay_group_id;

381: END LOOP;
382:
383: --IF l_counter = 0 THEN
384:
385: -- SELECT name INTO x_pay_group_roles(l_counter).name FROM CN_PAY_GROUPS WHERE PAY_GROUP_ID= p_pay_group_id;
386:
387: -- END IF;
388:
389: -- End of API body.