APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_PAY_GROUPS

Line 151: FROM cn_pay_groups_all

147: --
148:
149: SELECT start_date, end_date
150: INTO l_pp_start_date, l_pp_end_date
151: FROM cn_pay_groups_all
152: WHERE pay_group_id = p_pay_group_id;
153: IF ( (
154: ( l_pp_start_date IS NOT NULL) AND ( l_pp_end_date IS NOT NULL)
155: AND(

Line 185: FROM cn_pay_groups_all

181: -- pay group.
182: --
183: SELECT COUNT(1)
184: INTO l_count
185: FROM cn_pay_groups_all
186: WHERE (( p_start_date NOT BETWEEN start_date AND end_date )
187: OR (p_end_date NOT BETWEEN start_date AND end_date))
188: AND pay_group_id = p_pay_group_id;
189:

Line 501: l_pay_group_name cn_pay_groups.name%TYPE;

497: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
498: l_status VARCHAR2(30);
499: l_employee_number cn_salesreps.employee_number%TYPE;
500: l_employee_name cn_salesreps.name%TYPE;
501: l_pay_group_name cn_pay_groups.name%TYPE;
502:
503: CURSOR get_roles (p_salesrep_id NUMBER) IS
504: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date
505: FROM cn_srp_roles

Line 703: from cn_pay_groups_all

699: -- after paygroup is assigned
700:
701: select name
702: into l_pay_group_name
703: from cn_pay_groups_all
704: where pay_group_id = p_paygroup_assign_rec.pay_group_id;
705:
706: cn_mark_events_pkg.mark_event_srp_pay_group
707: ('CHANGE_SRP_PAY_GROUP', -- event name

Line 877: l_pay_group_name cn_pay_groups.name%TYPE;

873: l_old_lock_flag VARCHAR2(1);
874: l_status VARCHAR2(30);
875: l_employee_number cn_salesreps.employee_number%TYPE;
876: l_employee_name cn_salesreps.name%TYPE;
877: l_pay_group_name cn_pay_groups.name%TYPE;
878: l_dummy NUMBER;
879: l_srp_role_id NUMBER;
880:
881:

Line 1260: from cn_pay_groups_all

1256: -- range change as a result of the paygroup daterange change
1257:
1258: select name
1259: into l_pay_group_name
1260: from cn_pay_groups_all
1261: where pay_group_id = p_paygroup_assign_rec.pay_group_id;
1262:
1263: cn_mark_events_pkg.mark_event_srp_pay_group
1264: ('CHANGE_SRP_PAY_GROUP_DATE', -- event name

Line 1853: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

1849: l_loading_status VARCHAR2(2000);
1850:
1851: newrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1852: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1853: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1854: l_pg_start_date cn_pay_groups.start_date%TYPE;
1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;

Line 1854: l_pg_start_date cn_pay_groups.start_date%TYPE;

1850:
1851: newrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1852: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1853: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1854: l_pg_start_date cn_pay_groups.start_date%TYPE;
1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;

Line 1855: l_pg_end_date cn_pay_groups.end_date%TYPE;

1851: newrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1852: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1853: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1854: l_pg_start_date cn_pay_groups.start_date%TYPE;
1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;

Line 1897: from cn_srp_pay_groups_all spp, cn_pay_groups_all cpp

1893: select spp.start_date, spp.end_date, spp.salesrep_id,
1894: spp.lock_flag,cpp.pay_group_id, spp.org_id
1895: into l_start_date, l_end_date, l_salesrep_id,
1896: l_lock_flag,l_pay_group_id, l_org_id
1897: from cn_srp_pay_groups_all spp, cn_pay_groups_all cpp
1898: where spp.role_pay_group_id = p_role_pay_group_id
1899: AND spp.salesrep_id = l_salesrep_id
1900: AND cpp.pay_group_id = spp.pay_group_id
1901: AND Greatest(spp.start_date, l_srp_start_date) <=