APPS.CN_SRP_PERIODS_PVT dependencies on CN_SRP_PAY_GROUPS_ALL
Line 432: FROM cn_srp_pay_groups_all spg,cn_pay_groups_all pg
428:
429: CURSOR c_srp_pay_grp_csr IS
430: (SELECT spg.pay_group_id, spg.start_date, spg.end_date,
431: pg.period_set_id, pg.period_type_id 432: FROM cn_srp_pay_groups_all spg,cn_pay_groups_all pg 433: WHERE spg.salesrep_id = p_salesrep_id
434: AND spg.org_id = l_org_id
435: AND spg.pay_group_id = pg.pay_group_id
436: AND ( ( (p_end_date IS NOT NULL) AND (spg.end_date IS NOT NULL)