[Home] [Help]
72: --
73: type t_ass_amd_rec is record(
74: assignment_id number,
75: assignment_number per_all_assignments_f.assignment_number%type,
76: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);
77: type t_ass_amd_tbl is table of t_ass_amd_rec index by binary_integer;
78: g_ass_amd_ind_tbl t_ass_amd_tbl;
79: --
80: type t_imp_file_rec is record(
698: --
699: l_proc varchar2(80) := c_package||'imp_file_data';
700: --
701: l_assignment_id per_all_assignments_f.assignment_id%type;
702: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
703: --
704: l_district_code_o per_addresses.town_or_city%type;
705: l_organization_id_o number;
706: l_input_file_name_o pay_jp_swot_numbers.input_file_name%type;
721: organization_id number,
722: swot_number pay_jp_swot_numbers.swot_number%type,
723: input_file_name pay_jp_swot_numbers.input_file_name%type,
724: assignment_number per_all_assignments_f.assignment_number%type,
725: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type,
726: regular_payment_date date);
727: type t_ass_file_tbl is table of t_ass_file_rec index by binary_integer;
728: l_ass_file_tbl t_ass_file_tbl;
729: --
844: is
845: select hasa.assignment_id,
846: pa.assignment_number,
847: hasa.include_or_exclude
848: from hr_assignment_set_amendments hasa,
849: per_all_assignments_f pa,
850: per_time_periods ptp
851: where hasa.assignment_set_id = g_assignment_set_id
852: and pa.assignment_id = hasa.assignment_id
1564: --
1565: l_valid boolean;
1566: --
1567: l_assignment_id per_all_assignments_f.assignment_id%type;
1568: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
1569: --
1570: l_non_res_date date;
1571: l_res_date date;
1572: l_non_res_flag hr_lookups.lookup_code%type;