DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 521: FROM cn_srp_plan_assigns_all

517: p_salesrep_id NUMBER) IS
518: SELECT comp_plan_id,
519: start_date,
520: end_date
521: FROM cn_srp_plan_assigns_all
522: WHERE role_id = p_role_id
523: AND salesrep_id = p_salesrep_id
524: AND org_id = p_paygroup_assign_rec.org_id;
525:

Line 847: FROM cn_srp_plan_assigns_all

843: p_salesrep_id NUMBER) IS
844: SELECT comp_plan_id,
845: start_date,
846: end_date
847: FROM cn_srp_plan_assigns_all
848: WHERE role_id = p_role_id
849: AND salesrep_id = p_salesrep_id
850: AND org_id = p_paygroup_assign_rec.org_id;
851:

Line 1613: FROM cn_srp_plan_assigns_all

1609: p_salesrep_id NUMBER) IS
1610: SELECT comp_plan_id,
1611: start_date,
1612: end_date
1613: FROM cn_srp_plan_assigns_all
1614: WHERE role_id = p_role_id
1615: AND salesrep_id = p_salesrep_id
1616: AND org_id = p_paygroup_assign_rec.org_id;
1617: