DBA Data[Home] [Help]

APPS.GHR_WGI_PKG dependencies on HR_LOCATIONS

Line 99: l_org_address_line1 hr_locations.address_line_1%TYPE;

95: l_organization_id per_assignments.organization_id%TYPE;
96: l_proc VARCHAR2 (30) := 'AWGI :';
97: l_pay_basis per_pay_bases.pay_basis%TYPE;
98: l_organization_name hr_organization_units.NAME%TYPE;
99: l_org_address_line1 hr_locations.address_line_1%TYPE;
100: l_org_address_line2 hr_locations.address_line_2%TYPE;
101: l_org_address_line3 hr_locations.address_line_3%TYPE;
102: l_org_city hr_locations.town_or_city%TYPE;
103: l_org_state hr_locations.region_2%TYPE;

Line 100: l_org_address_line2 hr_locations.address_line_2%TYPE;

96: l_proc VARCHAR2 (30) := 'AWGI :';
97: l_pay_basis per_pay_bases.pay_basis%TYPE;
98: l_organization_name hr_organization_units.NAME%TYPE;
99: l_org_address_line1 hr_locations.address_line_1%TYPE;
100: l_org_address_line2 hr_locations.address_line_2%TYPE;
101: l_org_address_line3 hr_locations.address_line_3%TYPE;
102: l_org_city hr_locations.town_or_city%TYPE;
103: l_org_state hr_locations.region_2%TYPE;
104: l_org_country hr_locations.country%TYPE;

Line 101: l_org_address_line3 hr_locations.address_line_3%TYPE;

97: l_pay_basis per_pay_bases.pay_basis%TYPE;
98: l_organization_name hr_organization_units.NAME%TYPE;
99: l_org_address_line1 hr_locations.address_line_1%TYPE;
100: l_org_address_line2 hr_locations.address_line_2%TYPE;
101: l_org_address_line3 hr_locations.address_line_3%TYPE;
102: l_org_city hr_locations.town_or_city%TYPE;
103: l_org_state hr_locations.region_2%TYPE;
104: l_org_country hr_locations.country%TYPE;
105: l_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;

Line 102: l_org_city hr_locations.town_or_city%TYPE;

98: l_organization_name hr_organization_units.NAME%TYPE;
99: l_org_address_line1 hr_locations.address_line_1%TYPE;
100: l_org_address_line2 hr_locations.address_line_2%TYPE;
101: l_org_address_line3 hr_locations.address_line_3%TYPE;
102: l_org_city hr_locations.town_or_city%TYPE;
103: l_org_state hr_locations.region_2%TYPE;
104: l_org_country hr_locations.country%TYPE;
105: l_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;
106: l_pay_table_plan_id ghr_pay_plans.pay_plan%TYPE;

Line 103: l_org_state hr_locations.region_2%TYPE;

99: l_org_address_line1 hr_locations.address_line_1%TYPE;
100: l_org_address_line2 hr_locations.address_line_2%TYPE;
101: l_org_address_line3 hr_locations.address_line_3%TYPE;
102: l_org_city hr_locations.town_or_city%TYPE;
103: l_org_state hr_locations.region_2%TYPE;
104: l_org_country hr_locations.country%TYPE;
105: l_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;
106: l_pay_table_plan_id ghr_pay_plans.pay_plan%TYPE;
107: l_wgi_pay_date DATE;

Line 104: l_org_country hr_locations.country%TYPE;

100: l_org_address_line2 hr_locations.address_line_2%TYPE;
101: l_org_address_line3 hr_locations.address_line_3%TYPE;
102: l_org_city hr_locations.town_or_city%TYPE;
103: l_org_state hr_locations.region_2%TYPE;
104: l_org_country hr_locations.country%TYPE;
105: l_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;
106: l_pay_table_plan_id ghr_pay_plans.pay_plan%TYPE;
107: l_wgi_pay_date DATE;
108: l_wgi_due_date DATE; -- Bug 3747024