DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SRP_PLAN_ASSIGNS_PVT

Line 411: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

407:
408: FOR l_rec IN l_cur
409: LOOP
410:
411: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
412: (
413: p_api_version => 1.0,
414: x_return_status => l_return_status,
415: x_msg_count => l_msg_count,

Line 682: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

678: AND nvl(p_paygroup_assign_rec.assignment_end_date,l_null_date) >= roles.start_date)
679: ) THEN
680:
681: FOR role_plans IN get_role_plans(roles.role_id) LOOP
682: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
683: (p_api_version => 1.0,
684: x_return_status => x_return_status,
685: x_msg_count => x_msg_count,
686: x_msg_data => x_msg_data,

Line 1238: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1234: (roles.start_date <= greatest(nvl(p_paygroup_assign_rec.assignment_end_date, l_null_date), nvl(l_old_assignment_end_date, l_null_date))
1235: AND roles.end_date >= greatest(nvl(p_paygroup_assign_rec.assignment_end_date, l_null_date), nvl(l_old_assignment_end_date, l_null_date)) ) )
1236: ) THEN
1237: FOR role_plans IN get_role_plans(roles.role_id) LOOP
1238: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1239: (
1240: p_api_version => 1.0,
1241: x_return_status => x_return_status,
1242: x_msg_count => x_msg_count,

Line 1723: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1719: paygroups.end_date ) ) THEN
1720:
1721: FOR role_plans IN get_role_plans(roles.role_id)
1722: LOOP
1723: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1724: ( p_api_version => 1.0,
1725: x_return_status => x_return_status,
1726: x_msg_count => x_msg_count,
1727: x_msg_data => x_msg_data,