583: ,contract per_contracts_f.reference%type
584: ,collective_agreement per_collective_agreements.name%type
585: ,cagr_id_flex_name fnd_id_flex_structures_v.id_flex_structure_name%type
586: ,cagr_grade varchar2(1)
587: ,establishment hr_leg_establishments_v.name%type);
588:
589: type findtab is table of findrec
590: index by binary_integer;
591:
665: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
666: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667: ,employment_category_meaning hr_lookups.meaning%type default null
668: ,employment_category per_all_assignments_f.employment_category%type default null
669: ,establishment hr_leg_establishments_v.name%type default null
670: ,establishment_id hr_leg_establishments_v.organization_id%type default null
671: ,projected_hire_date per_applications.projected_hire_date%type default null
672: ,secure varchar2 default null
673: ,field1_name varchar2 default null
666: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667: ,employment_category_meaning hr_lookups.meaning%type default null
668: ,employment_category per_all_assignments_f.employment_category%type default null
669: ,establishment hr_leg_establishments_v.name%type default null
670: ,establishment_id hr_leg_establishments_v.organization_id%type default null
671: ,projected_hire_date per_applications.projected_hire_date%type default null
672: ,secure varchar2 default null
673: ,field1_name varchar2 default null
674: ,field1_condition_code varchar2 default null
769: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
770: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771: ,employment_category_meaning in hr_lookups.meaning%type default null
772: ,employment_category in per_all_assignments_f.employment_category%type default null
773: ,establishment in hr_leg_establishments_v.name%type default null
774: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
775: ,projected_hire_date in per_applications.projected_hire_date%type default null
776: ,secure in varchar2 default null
777: ,field1_name in varchar2 default null
770: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771: ,employment_category_meaning in hr_lookups.meaning%type default null
772: ,employment_category in per_all_assignments_f.employment_category%type default null
773: ,establishment in hr_leg_establishments_v.name%type default null
774: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
775: ,projected_hire_date in per_applications.projected_hire_date%type default null
776: ,secure in varchar2 default null
777: ,field1_name in varchar2 default null
778: ,field1_condition_code in varchar2 default null