DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 77: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);

73: person_id number,
74: assignment_id number,
75: assignment_action_id number,
76: effective_date date,
77: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);
78: type t_ass_tbl is table of t_ass_rec index by binary_integer;
79: g_ass_tbl t_ass_tbl;
80: g_ass_ind_tbl t_ass_tbl;
81: --

Line 556: hr_assignment_set_amendments hasa

552: hasa.include_or_exclude
553: from pay_population_ranges ppr,
554: per_periods_of_service ppos,
555: per_assignments_f pa,
556: hr_assignment_set_amendments hasa
557: where ppr.payroll_action_id = p_payroll_action_id
558: and ppr.chunk_number = p_chunk_number
559: and ppos.person_id = ppr.person_id
560: and ppos.business_group_id + 0 = g_business_group_id

Line 700: hr_assignment_set_amendments hasa,

696: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date,
697: hasa.include_or_exclude
698: from per_periods_of_service ppos,
699: per_assignments_f pa,
700: hr_assignment_set_amendments hasa,
701: per_people_f pp
702: where ppos.person_id
703: between p_start_person_id and p_end_person_id
704: and ppos.business_group_id + 0 = g_business_group_id