APPS.CN_PAYGROUP_PVT dependencies on CN_PAY_GROUPS

Line 29: FROM cn_pay_groups

25: l_api_name CONSTANT VARCHAR2(30) := 'Get_PayGroup_ID';
26:
27: CURSOR get_PayGroup_id is
28: SELECT pay_group_id
29: FROM cn_pay_groups
30: WHERE name = p_PayGroup_rec.name
31: AND start_date = p_PayGroup_rec.start_date
32: AND end_date = p_PayGroup_rec.end_date
33: and org_id= p_PayGroup_rec.org_id;

Line 48: SELECT cn_pay_groups_s.nextval

44: IF get_PayGroup_id%ROWCOUNT = 0
45: THEN
46: x_status := 'NEW PAY GROUP';
47: x_pay_group_id := l_get_PayGroup_id_rec.pay_group_id;
48: SELECT cn_pay_groups_s.nextval
49: INTO x_pay_group_id
50: FROM dual;
51: ELSIF get_PayGroup_id%ROWCOUNT = 1
52: THEN

Line 257: -- CN_Pay_Groups_Pkg.Begin_Record

253: --------------------------------------------------------------------------+
254: -- Procedure : Create_PayGroup
255: -- Description: Public API to create a pay group
256: -- Calls : validate_pay_group
257: -- CN_Pay_Groups_Pkg.Begin_Record
258: --------------------------------------------------------------------------+
259: PROCEDURE Create_PayGroup(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 ,

Line 370: FROM cn_pay_groups

366: END IF;
367:
368: SELECT COUNT(*)
369: INTO l_count
370: FROM cn_pay_groups
371: WHERE name = p_PayGroup_rec.name
372: AND start_date = p_PayGroup_rec.start_date
373: AND end_date = p_PayGroup_rec.end_date
374: and org_id = p_PayGroup_rec.org_id;

Line 402: FROM cn_pay_groups

398: BEGIN
399: SELECT 1 INTO l_dummy FROM dual
400: WHERE NOT EXISTS
401: ( SELECT 1
402: FROM cn_pay_groups
403: WHERE
404: ((end_date IS NOT NULL) AND
405: (p_paygroup_rec.end_date IS NOT NULL) AND
406: ((start_date BETWEEN p_paygroup_rec.start_date

Line 476: CN_Pay_Groups_Pkg.Begin_Record

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: CLOSE get_period_type_id;
476: CN_Pay_Groups_Pkg.Begin_Record
477: (
478: x_operation => 'INSERT',
479: x_rowid => L_ROWID,
480: x_pay_group_id => l_pay_group_id,

Line 575: -- CN_Pay_Groups_Pkg.Begin_Record

571: ---------------------------------------------------------------------------+
572: -- Procedure : Update PayGroup
573: -- Description : This is a public procedure to update pay groups
574: -- Calls : validate_pay_group
575: -- CN_Pay_Groups_Pkg.Begin_Record
576: ---------------------------------------------------------------------------+
577:
578: PROCEDURE Update_PayGroup (
579: p_api_version IN NUMBER,

Line 631: FROM cn_pay_groups

627:
628:
629: CURSOR get_pay_group (p_pay_group_id NUMBER) IS
630: SELECT *
631: FROM cn_pay_groups
632: WHERE pay_group_id = p_pay_group_id;
633: l_pg_rec get_pay_group%ROWTYPE;
634:
635: cursor get_old_pay_group is

Line 662: from cn_pay_groups

658: attribute14,
659: attribute15,
660: object_version_number,
661: org_id
662: from cn_pay_groups
663: where pay_group_id = p_paygroup_rec.pay_group_id;
664:
665: -- get the all the salesrep assigned to this salesreps and the the
666: -- data should fall with in the srp Paygroups

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 849: FROM cn_pay_groups

845: -- Kumar.
846:
847: SELECT COUNT(*)
848: INTO l_count
849: FROM cn_pay_groups
850: WHERE name = p_PayGroup_rec.name
851: AND start_date = p_PayGroup_rec.start_date
852: AND end_date = p_PayGroup_rec.end_date
853: and org_id = p_PayGroup_rec.org_id

Line 879: FROM cn_pay_groups

875: BEGIN
876: SELECT 1 INTO l_dummy FROM dual
877: WHERE NOT EXISTS
878: ( SELECT 1
879: FROM cn_pay_groups
880: WHERE
881: ((end_date IS NOT NULL) AND
882: (p_paygroup_rec.end_date IS NOT NULL) AND
883: ((start_date BETWEEN p_paygroup_rec.start_date

Line 1090: FROM cn_pay_groups pg,

1086: BEGIN
1087: SELECT 1 INTO l_dummy FROM dual
1088: WHERE NOT EXISTS
1089: ( SELECT 1
1090: FROM cn_pay_groups pg,
1091: cn_payruns p
1092: WHERE pg.pay_group_id = p.pay_group_id
1093: and pg.org_id = p.org_id
1094: AND pg.pay_group_id = l_pay_group_id

Line 1170: Cn_Pay_Groups_Pkg.Begin_Record(

1166:
1167: -- Period Type is not update check
1168:
1169:
1170: Cn_Pay_Groups_Pkg.Begin_Record(
1171: x_operation => 'UPDATE',
1172: x_rowid => L_ROWID,
1173: x_pay_group_id => l_pay_group_id,
1174: x_name => p_PayGroup_rec.name,

Line 1461: cn_pay_groups_pkg.begin_record

1457: x_loading_status := 'CN_PAY_GROUP_CHANGE_NA';
1458: RAISE FND_API.G_EXC_ERROR ;
1459:
1460: ELSE
1461: cn_pay_groups_pkg.begin_record
1462: (
1463: x_operation => 'DELETE',
1464: x_rowid => L_ROWID,
1465: x_pay_group_id => l_pay_group_id,