DBA Data[Home] [Help]

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)