APPS.CN_PAYGROUP_PVT dependencies on CN_SRP_PAY_GROUPS

Line 669: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,

665: -- get the all the salesrep assigned to this salesreps and the the
666: -- data should fall with in the srp Paygroups
667: -- Added KS
668: CURSOR get_srp_pay_group_id_cur (
669: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
670: c_start_date cn_srp_pay_groups.start_date%TYPE,
671: c_end_date cn_srp_pay_groups.end_date%TYPE,
672: c_org_id cn_srp_pay_groups.org_id%TYPE) IS
673: SELECT salesrep_id

Line 670: c_start_date cn_srp_pay_groups.start_date%TYPE,

666: -- data should fall with in the srp Paygroups
667: -- Added KS
668: CURSOR get_srp_pay_group_id_cur (
669: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
670: c_start_date cn_srp_pay_groups.start_date%TYPE,
671: c_end_date cn_srp_pay_groups.end_date%TYPE,
672: c_org_id cn_srp_pay_groups.org_id%TYPE) IS
673: SELECT salesrep_id
674: FROM cn_srp_pay_groups

Line 671: c_end_date cn_srp_pay_groups.end_date%TYPE,

667: -- Added KS
668: CURSOR get_srp_pay_group_id_cur (
669: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
670: c_start_date cn_srp_pay_groups.start_date%TYPE,
671: c_end_date cn_srp_pay_groups.end_date%TYPE,
672: c_org_id cn_srp_pay_groups.org_id%TYPE) IS
673: SELECT salesrep_id
674: FROM cn_srp_pay_groups
675: WHERE pay_group_id = c_pay_group_id

Line 672: c_org_id cn_srp_pay_groups.org_id%TYPE) IS

668: CURSOR get_srp_pay_group_id_cur (
669: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
670: c_start_date cn_srp_pay_groups.start_date%TYPE,
671: c_end_date cn_srp_pay_groups.end_date%TYPE,
672: c_org_id cn_srp_pay_groups.org_id%TYPE) IS
673: SELECT salesrep_id
674: FROM cn_srp_pay_groups
675: WHERE pay_group_id = c_pay_group_id
676: AND trunc(start_date) = trunc(c_start_date)

Line 674: FROM cn_srp_pay_groups

670: c_start_date cn_srp_pay_groups.start_date%TYPE,
671: c_end_date cn_srp_pay_groups.end_date%TYPE,
672: c_org_id cn_srp_pay_groups.org_id%TYPE) IS
673: SELECT salesrep_id
674: FROM cn_srp_pay_groups
675: WHERE pay_group_id = c_pay_group_id
676: AND trunc(start_date) = trunc(c_start_date)
677: AND trunc(nvl(end_date, l_null_date)) = trunc(nvl(c_end_date, l_null_date))
678: AND org_id = c_org_id;

Line 709: from cn_srp_pay_groups spg, cn_pay_groups pg,

705: l_old_period_set_id NUMBER;
706:
707: CURSOR get_affected_reps IS
708: select sr.srp_role_id, rp.role_plan_id
709: from cn_srp_pay_groups spg, cn_pay_groups pg,
710: cn_srp_roles sr, cn_role_plans rp
711: where spg.end_date is null
712: and spg.pay_group_id = pg.pay_group_id
713: and pg.pay_group_id = p_paygroup_rec.pay_group_id

Line 907: FROM cn_srp_pay_groups

903:
904:
905: SELECT COUNT(1)
906: INTO l_count
907: FROM cn_srp_pay_groups
908: WHERE pay_group_id = l_pay_group_id;
909:
910:
911: IF l_count <> 0

Line 920: FROM cn_srp_pay_groups

916: CLOSE get_pay_group;
917:
918: SELECT MIN(start_date),MAX(end_date)
919: INTO l_start_date,l_end_date
920: FROM cn_srp_pay_groups
921: WHERE pay_group_id = l_pay_group_id;
922:
923: IF l_start_date < p_paygroup_rec.start_date
924: OR l_end_date > p_paygroup_rec.end_date

Line 1041: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp

1037: END IF;
1038:
1039: select 1 into l_valid_data from dual where exists
1040: (select count(cp.pay_date) from
1041: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp
1042: where
1043: cp.payrun_id = cpw.payrun_id and cp.pay_group_id = cspg.pay_group_id and
1044: cp.org_id = cpw.org_id and cp.org_id = cspg.org_id and
1045: cpw.salesrep_id = cspg.salesrep_id and cpw.org_id = cspg.org_id and

Line 1051: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp,cn_period_statuses cps

1047:
1048: if(l_valid_data = 1) then
1049: begin
1050: select max(cps.end_date) into l_pay_period_end_date from
1051: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp,cn_period_statuses cps
1052: where
1053: cp.payrun_id = cpw.payrun_id and cp.pay_group_id = cspg.pay_group_id and
1054: cp.org_id = cpw.org_id and cp.org_id = cspg.org_id and
1055: cpw.salesrep_id = cspg.salesrep_id and cpw.org_id = cspg.org_id and

Line 1127: cn_srp_pay_groups spg

1123: WHERE NOT EXISTS
1124: ( SELECT 1
1125: FROM cn_srp_periods csp,
1126: cn_posting_details_sum cpd,
1127: cn_srp_pay_groups spg
1128: WHERE cpd.credited_salesrep_id = spg.salesrep_id
1129: and cpd.pay_period_id = csp.period_id
1130: and csp.salesrep_id = cpd.credited_salesrep_id
1131: and csp.org_id = cpd.org_id

Line 1445: FROM cn_srp_pay_groups

1441:
1442:
1443: SELECT COUNT(1)
1444: INTO l_count
1445: FROM cn_srp_pay_groups
1446: WHERE pay_group_id = l_pay_group_id;
1447:
1448: IF l_count <> 0
1449: THEN