DBA Data[Home] [Help]

APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PER_ASSIGNMENTS_F

Line 681: per_assignments_f paf,

677: scl.SEGMENT10 def_wrk_patt ,
678: ppf.payroll_id payroll_id ,
679: ppf.PRL_INFORMATION1 holiday_card
680: FROM pay_payrolls_f ppf,
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

Line 724: l_ass_no per_assignments_f.ASSIGNMENT_NUMBER%TYPE;

720: AND p_effective_date BETWEEN hou.DATE_FROM AND nvl(hou.DATE_TO, p_effective_date);
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;