DBA Data[Home] [Help]

APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PER_PEOPLE_F

Line 685: per_people_f papf

681: per_assignments_f paf,
682: hr_organization_units hou,
683: hr_organization_information hoi,
684: hr_soft_coding_keyflex scl ,
685: per_people_f papf
686: WHERE hou.business_group_id = p_business_group_id
687: AND hou.organization_id = g_legal_employer_id
688: AND hou.organization_id = hoi.organization_id
689: AND hoi.org_information_context = 'CLASS'

Line 725: l_cvr_no per_people_f.NATIONAL_IDENTIFIER%TYPE;

721:
722: l_5d_6d hr_soft_coding_keyflex.SEGMENT10%type;
723: l_work_pattern HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%type;
724: l_ass_no per_assignments_f.ASSIGNMENT_NUMBER%TYPE;
725: l_cvr_no per_people_f.NATIONAL_IDENTIFIER%TYPE;
726: l_flag number;
727: l_start_date date;
728: l_end_date date;
729: l_holidays varchar2(20);