DBA Data[Home] [Help]

APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_PAY_GROUPS

Line 13: pay_groups_name cn_pay_groups.name%TYPE ,

9: TYPE role_pay_groups_rec_type IS RECORD
10: (
11: role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE := cn_api.G_MISS_ID,
12: role_name cn_roles.name%TYPE ,
13: pay_groups_name cn_pay_groups.name%TYPE ,
14: start_date cn_role_pay_groups.start_date%TYPE ,
15: end_date cn_role_pay_groups.end_date%TYPE ,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,

Line 84: -- 6. Pay_Group_name must exist in cn_pay_groups already.

80: -- 2. Pay group name can not be missing or null.
81: -- 3. Start_date can not be missing or null.
82: -- 4. Start_date <= end_date, if end_date is not null.
83: -- 5. Role name must exist in cn_roles already.
84: -- 6. Pay_Group_name must exist in cn_pay_groups already.
85: -- 7. Date range (start_date, en_date) of the assignment must be
86: -- within the date range (start_date, end_date) of the comp plan.
87: -- 8. No pay group overlap for the any same sales role.
88: -- In other words, you can not have more than one pay group for