DBA Data[Home] [Help]

APPS.PER_QH_FIND_QUERY dependencies on HR_LEG_ESTABLISHMENTS_V

Line 587: ,establishment hr_leg_establishments_v.name%type);

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:

Line 669: ,establishment hr_leg_establishments_v.name%type default null

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

Line 670: ,establishment_id hr_leg_establishments_v.organization_id%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
674: ,field1_condition_code varchar2 default null

Line 773: ,establishment in hr_leg_establishments_v.name%type 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

Line 774: ,establishment_id in hr_leg_establishments_v.organization_id%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
778: ,field1_condition_code in varchar2 default null