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.ZX_TDS_PROCESS_CEC_PVT dependencies on HR_LOCATIONS_ALL

Line 53: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,

49:
50: pr_site_loc_rec pr_site_loc_rec_type;
51:
52: TYPE pr_org_loc_rec_type is RECORD(
53: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
54: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 54: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

50: pr_site_loc_rec pr_site_loc_rec_type;
51:
52: TYPE pr_org_loc_rec_type is RECORD(
53: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
54: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

Line 55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

51:
52: TYPE pr_org_loc_rec_type is RECORD(
53: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
54: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

Line 56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

52: TYPE pr_org_loc_rec_type is RECORD(
53: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
54: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

Line 57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

53: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
54: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

54: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,

Line 59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

55: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,

Line 60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

56: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,

Line 61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

57: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
65: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

Line 62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,

58: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
65: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
66: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523

Line 63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,

59: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
65: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
66: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
67: -- ORGANIZATION_ID NUMBER

Line 64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,

60: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
65: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
66: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
67: -- ORGANIZATION_ID NUMBER
68: );

Line 65: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

61: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
65: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
66: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
67: -- ORGANIZATION_ID NUMBER
68: );
69:

Line 66: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523

62: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
63: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
64: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
65: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
66: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
67: -- ORGANIZATION_ID NUMBER
68: );
69:
70: pr_org_loc_rec pr_org_loc_rec_type;

Line 579: from hr_locations_all loc,

575: loc.TELEPHONE_NUMBER_2,
576: loc.TELEPHONE_NUMBER_3,
577: loc.STYLE,
578: loc.LOCATION_ID
579: from hr_locations_all loc,
580: fnd_descr_flex_contexts fnd
581: where loc.location_id = c_location_id
582: AND loc.style = fnd.descriptive_flex_context_code
583: AND fnd.application_id = 800 -- Application_short_name 'PER'