DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_API dependencies on PER_ROLES

Line 3204: from per_roles

3200: select
3201: role_id
3202: , object_version_number
3203: , end_date
3204: from per_roles
3205: where person_id = p_person_id
3206: and p_actual_termination_date
3207: between start_date
3208: and nvl(end_date, hr_api.g_eot);

Line 3212: from per_roles

3208: and nvl(end_date, hr_api.g_eot);
3209:
3210: cursor csr_chk_addl_rights is
3211: select role_id
3212: from per_roles
3213: where person_id = p_person_id
3214: and EMP_RIGHTS_FLAG = 'Y'
3215: and nvl(end_of_rights_date, hr_api.g_eot) > p_actual_termination_date;
3216: -- end fix 1370960

Line 3705: per_roles

3701: cursor csr_roles is
3702: select role_id
3703: ,object_version_number
3704: ,old_end_date from
3705: per_roles
3706: where person_id = p_person_id
3707: and end_date = p_actual_termination_date
3708: for update nowait;
3709: -- fix 1370960 end