eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PERSON dependencies on HR_LOCATIONS

Line 231: g_location_code hr_locations.location_code%TYPE;

227: g_employee_status per_assignment_status_types.user_status%TYPE;
228: g_employee_grade per_grades.name%TYPE;
229: g_employee_organization per_all_organization_units.name%TYPE;
230: --
231: g_location_code hr_locations.location_code%TYPE;
232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;

Line 232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;

228: g_employee_grade per_grades.name%TYPE;
229: g_employee_organization per_all_organization_units.name%TYPE;
230: --
231: g_location_code hr_locations.location_code%TYPE;
232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;

Line 233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;

229: g_employee_organization per_all_organization_units.name%TYPE;
230: --
231: g_location_code hr_locations.location_code%TYPE;
232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;

Line 234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;

230: --
231: g_location_code hr_locations.location_code%TYPE;
232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;
238: g_location_region1 hr_locations.REGION_1%TYPE;

Line 235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;

231: g_location_code hr_locations.location_code%TYPE;
232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;
238: g_location_region1 hr_locations.REGION_1%TYPE;
239: g_location_region2 hr_locations.REGION_2%TYPE;

Line 236: g_location_country hr_locations.COUNTRY%TYPE;

232: g_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;
238: g_location_region1 hr_locations.REGION_1%TYPE;
239: g_location_region2 hr_locations.REGION_2%TYPE;
240: g_location_region3 hr_locations.REGION_3%TYPE;

Line 237: g_location_zip hr_locations.POSTAL_CODE%TYPE;

233: g_location_addr2 hr_locations.ADDRESS_LINE_2%TYPE;
234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;
238: g_location_region1 hr_locations.REGION_1%TYPE;
239: g_location_region2 hr_locations.REGION_2%TYPE;
240: g_location_region3 hr_locations.REGION_3%TYPE;
241: --

Line 238: g_location_region1 hr_locations.REGION_1%TYPE;

234: g_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;
238: g_location_region1 hr_locations.REGION_1%TYPE;
239: g_location_region2 hr_locations.REGION_2%TYPE;
240: g_location_region3 hr_locations.REGION_3%TYPE;
241: --
242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;

Line 239: g_location_region2 hr_locations.REGION_2%TYPE;

235: g_location_city hr_locations.TOWN_OR_CITY%TYPE;
236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;
238: g_location_region1 hr_locations.REGION_1%TYPE;
239: g_location_region2 hr_locations.REGION_2%TYPE;
240: g_location_region3 hr_locations.REGION_3%TYPE;
241: --
242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;

Line 240: g_location_region3 hr_locations.REGION_3%TYPE;

236: g_location_country hr_locations.COUNTRY%TYPE;
237: g_location_zip hr_locations.POSTAL_CODE%TYPE;
238: g_location_region1 hr_locations.REGION_1%TYPE;
239: g_location_region2 hr_locations.REGION_2%TYPE;
240: g_location_region3 hr_locations.REGION_3%TYPE;
241: --
242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;
244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;

Line 242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;

238: g_location_region1 hr_locations.REGION_1%TYPE;
239: g_location_region2 hr_locations.REGION_2%TYPE;
240: g_location_region3 hr_locations.REGION_3%TYPE;
241: --
242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;
244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;

Line 243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;

239: g_location_region2 hr_locations.REGION_2%TYPE;
240: g_location_region3 hr_locations.REGION_3%TYPE;
241: --
242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;
244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;

Line 244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;

240: g_location_region3 hr_locations.REGION_3%TYPE;
241: --
242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;
244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;

Line 245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;

241: --
242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;
244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;
249: g_org_location_region2 hr_locations.REGION_2%TYPE;

Line 246: g_org_location_country hr_locations.COUNTRY%TYPE;

242: g_org_location_addr1 hr_locations.ADDRESS_LINE_1%TYPE;
243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;
244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;
249: g_org_location_region2 hr_locations.REGION_2%TYPE;
250: g_org_location_region3 hr_locations.REGION_3%TYPE;

Line 247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;

243: g_org_location_addr2 Hr_locations.ADDRESS_LINE_2%TYPE;
244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;
249: g_org_location_region2 hr_locations.REGION_2%TYPE;
250: g_org_location_region3 hr_locations.REGION_3%TYPE;
251: g_org_location_phone hr_locations.Telephone_number_1%TYPE;

Line 248: g_org_location_region1 hr_locations.REGION_1%TYPE;

244: g_org_location_addr3 hr_locations.ADDRESS_LINE_3%TYPE;
245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;
249: g_org_location_region2 hr_locations.REGION_2%TYPE;
250: g_org_location_region3 hr_locations.REGION_3%TYPE;
251: g_org_location_phone hr_locations.Telephone_number_1%TYPE;
252: --

Line 249: g_org_location_region2 hr_locations.REGION_2%TYPE;

245: g_org_location_city Hr_locations.TOWN_OR_CITY%TYPE;
246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;
249: g_org_location_region2 hr_locations.REGION_2%TYPE;
250: g_org_location_region3 hr_locations.REGION_3%TYPE;
251: g_org_location_phone hr_locations.Telephone_number_1%TYPE;
252: --
253:

Line 250: g_org_location_region3 hr_locations.REGION_3%TYPE;

246: g_org_location_country hr_locations.COUNTRY%TYPE;
247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;
249: g_org_location_region2 hr_locations.REGION_2%TYPE;
250: g_org_location_region3 hr_locations.REGION_3%TYPE;
251: g_org_location_phone hr_locations.Telephone_number_1%TYPE;
252: --
253:
254: g_job per_jobs.name%TYPE;

Line 251: g_org_location_phone hr_locations.Telephone_number_1%TYPE;

247: g_org_location_zip hr_locations.POSTAL_CODE%TYPE;
248: g_org_location_region1 hr_locations.REGION_1%TYPE;
249: g_org_location_region2 hr_locations.REGION_2%TYPE;
250: g_org_location_region3 hr_locations.REGION_3%TYPE;
251: g_org_location_phone hr_locations.Telephone_number_1%TYPE;
252: --
253:
254: g_job per_jobs.name%TYPE;
255: g_position per_positions.name%TYPE;

Line 264: g_location_id hr_locations.location_id%TYPE;

260: --
261: g_employee_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
262: g_employee_grade_id per_grades.grade_id%TYPE;
263: g_employee_organization_id per_all_organization_units.organization_id%TYPE;
264: g_location_id hr_locations.location_id%TYPE;
265: g_job_id per_jobs.job_id%TYPE;
266: g_position_id per_positions.position_id%TYPE;
267: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
268: g_people_group_id pay_people_groups.people_group_id%TYPE;

Line 956: g_elig_cobra_admin_addr1 hr_locations.address_line_1%type ;

952: -- Cobra letter requirment
953: g_elig_cobra_payment_dys ben_pl_f.COBRA_PYMT_DUE_DY_NUM%type ;
954: g_elig_cobra_admin_name ben_popl_org_role_f.name%type ;
955: g_elig_cobra_admin_org_name hr_all_organization_units.name%type ;
956: g_elig_cobra_admin_addr1 hr_locations.address_line_1%type ;
957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;
958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;
959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;

Line 957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;

953: g_elig_cobra_payment_dys ben_pl_f.COBRA_PYMT_DUE_DY_NUM%type ;
954: g_elig_cobra_admin_name ben_popl_org_role_f.name%type ;
955: g_elig_cobra_admin_org_name hr_all_organization_units.name%type ;
956: g_elig_cobra_admin_addr1 hr_locations.address_line_1%type ;
957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;
958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;
959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;
961: g_elig_cobra_admin_country hr_locations.country%type ;

Line 958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;

954: g_elig_cobra_admin_name ben_popl_org_role_f.name%type ;
955: g_elig_cobra_admin_org_name hr_all_organization_units.name%type ;
956: g_elig_cobra_admin_addr1 hr_locations.address_line_1%type ;
957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;
958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;
959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;
961: g_elig_cobra_admin_country hr_locations.country%type ;
962: g_elig_cobra_admin_zip hr_locations.postal_code%type ;

Line 959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;

955: g_elig_cobra_admin_org_name hr_all_organization_units.name%type ;
956: g_elig_cobra_admin_addr1 hr_locations.address_line_1%type ;
957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;
958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;
959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;
961: g_elig_cobra_admin_country hr_locations.country%type ;
962: g_elig_cobra_admin_zip hr_locations.postal_code%type ;
963: g_elig_cobra_admin_phone hr_locations.telephone_number_1%type ;

Line 960: g_elig_cobra_admin_state hr_locations.region_2%type ;

956: g_elig_cobra_admin_addr1 hr_locations.address_line_1%type ;
957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;
958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;
959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;
961: g_elig_cobra_admin_country hr_locations.country%type ;
962: g_elig_cobra_admin_zip hr_locations.postal_code%type ;
963: g_elig_cobra_admin_phone hr_locations.telephone_number_1%type ;
964:

Line 961: g_elig_cobra_admin_country hr_locations.country%type ;

957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;
958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;
959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;
961: g_elig_cobra_admin_country hr_locations.country%type ;
962: g_elig_cobra_admin_zip hr_locations.postal_code%type ;
963: g_elig_cobra_admin_phone hr_locations.telephone_number_1%type ;
964:
965: --

Line 962: g_elig_cobra_admin_zip hr_locations.postal_code%type ;

958: g_elig_cobra_admin_addr3 hr_locations.address_line_3%type ;
959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;
961: g_elig_cobra_admin_country hr_locations.country%type ;
962: g_elig_cobra_admin_zip hr_locations.postal_code%type ;
963: g_elig_cobra_admin_phone hr_locations.telephone_number_1%type ;
964:
965: --
966: -- beneficiary

Line 963: g_elig_cobra_admin_phone hr_locations.telephone_number_1%type ;

959: g_elig_cobra_admin_city hr_locations.town_or_city%type ;
960: g_elig_cobra_admin_state hr_locations.region_2%type ;
961: g_elig_cobra_admin_country hr_locations.country%type ;
962: g_elig_cobra_admin_zip hr_locations.postal_code%type ;
963: g_elig_cobra_admin_phone hr_locations.telephone_number_1%type ;
964:
965: --
966: -- beneficiary
967: --

Line 1060: g_alc_flex_01 hr_locations.attribute1%TYPE;

1056: g_upd_cm_sent_dt_flag varchar2(30);
1057: --
1058: -- Flex fields
1059: --
1060: g_alc_flex_01 hr_locations.attribute1%TYPE;
1061: g_alc_flex_02 hr_locations.attribute2%TYPE;
1062: g_alc_flex_03 hr_locations.attribute3%TYPE;
1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;

Line 1061: g_alc_flex_02 hr_locations.attribute2%TYPE;

1057: --
1058: -- Flex fields
1059: --
1060: g_alc_flex_01 hr_locations.attribute1%TYPE;
1061: g_alc_flex_02 hr_locations.attribute2%TYPE;
1062: g_alc_flex_03 hr_locations.attribute3%TYPE;
1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;

Line 1062: g_alc_flex_03 hr_locations.attribute3%TYPE;

1058: -- Flex fields
1059: --
1060: g_alc_flex_01 hr_locations.attribute1%TYPE;
1061: g_alc_flex_02 hr_locations.attribute2%TYPE;
1062: g_alc_flex_03 hr_locations.attribute3%TYPE;
1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;

Line 1063: g_alc_flex_04 hr_locations.attribute4%TYPE;

1059: --
1060: g_alc_flex_01 hr_locations.attribute1%TYPE;
1061: g_alc_flex_02 hr_locations.attribute2%TYPE;
1062: g_alc_flex_03 hr_locations.attribute3%TYPE;
1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;
1067: g_alc_flex_08 hr_locations.attribute8%TYPE;

Line 1064: g_alc_flex_05 hr_locations.attribute5%TYPE;

1060: g_alc_flex_01 hr_locations.attribute1%TYPE;
1061: g_alc_flex_02 hr_locations.attribute2%TYPE;
1062: g_alc_flex_03 hr_locations.attribute3%TYPE;
1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;
1067: g_alc_flex_08 hr_locations.attribute8%TYPE;
1068: g_alc_flex_09 hr_locations.attribute9%TYPE;

Line 1065: g_alc_flex_06 hr_locations.attribute6%TYPE;

1061: g_alc_flex_02 hr_locations.attribute2%TYPE;
1062: g_alc_flex_03 hr_locations.attribute3%TYPE;
1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;
1067: g_alc_flex_08 hr_locations.attribute8%TYPE;
1068: g_alc_flex_09 hr_locations.attribute9%TYPE;
1069: g_alc_flex_10 hr_locations.attribute10%TYPE;

Line 1066: g_alc_flex_07 hr_locations.attribute7%TYPE;

1062: g_alc_flex_03 hr_locations.attribute3%TYPE;
1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;
1067: g_alc_flex_08 hr_locations.attribute8%TYPE;
1068: g_alc_flex_09 hr_locations.attribute9%TYPE;
1069: g_alc_flex_10 hr_locations.attribute10%TYPE;
1070: --

Line 1067: g_alc_flex_08 hr_locations.attribute8%TYPE;

1063: g_alc_flex_04 hr_locations.attribute4%TYPE;
1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;
1067: g_alc_flex_08 hr_locations.attribute8%TYPE;
1068: g_alc_flex_09 hr_locations.attribute9%TYPE;
1069: g_alc_flex_10 hr_locations.attribute10%TYPE;
1070: --
1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;

Line 1068: g_alc_flex_09 hr_locations.attribute9%TYPE;

1064: g_alc_flex_05 hr_locations.attribute5%TYPE;
1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;
1067: g_alc_flex_08 hr_locations.attribute8%TYPE;
1068: g_alc_flex_09 hr_locations.attribute9%TYPE;
1069: g_alc_flex_10 hr_locations.attribute10%TYPE;
1070: --
1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;
1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;

Line 1069: g_alc_flex_10 hr_locations.attribute10%TYPE;

1065: g_alc_flex_06 hr_locations.attribute6%TYPE;
1066: g_alc_flex_07 hr_locations.attribute7%TYPE;
1067: g_alc_flex_08 hr_locations.attribute8%TYPE;
1068: g_alc_flex_09 hr_locations.attribute9%TYPE;
1069: g_alc_flex_10 hr_locations.attribute10%TYPE;
1070: --
1071: g_prl_flex_01 pay_all_payrolls_f.attribute1%TYPE;
1072: g_prl_flex_02 pay_all_payrolls_f.attribute2%TYPE;
1073: g_prl_flex_03 pay_all_payrolls_f.attribute3%TYPE;

Line 1267: g_CWB_Person_LOCATION hr_locations.location_code%TYPE ;

1263: g_CWB_Person_GRADE_ANN_FACTOR ben_cwb_person_info.GRADE_ANNULIZATION_FACTOR%type ;
1264: g_CWB_Person_Grade_COMPARATIO ben_cwb_person_info.Grd_COMPARATIO%type ;
1265: g_CWB_Person_JOB_name per_jobs.name%type ;
1266: g_CWB_Person_LEGISLATION ben_cwb_person_info.LEGISLATION_CODE%type ;
1267: g_CWB_Person_LOCATION hr_locations.location_code%TYPE ;
1268: g_CWB_Person_NORMAL_HOURS ben_cwb_person_info.NORMAL_HOURS%type ;
1269: g_CWB_Person_ORG_name per_all_organization_units.name%TYPE;
1270: g_CWB_Person_ORIG_START_DATE ben_cwb_person_info.ORIGINAL_START_DATE%type ;
1271: g_CWB_Person_PAY_RATE varchar2(100) ;