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.PAY_NL_GENERAL dependencies on HR_GENERAL

Line 1163: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city

1159: ,pad.address_line1 address_line1
1160: ,pad.address_line2 address_line2
1161: ,pad.address_line3 address_line3
1162: ,get_postal_code(pad.postal_code) postcode --get the postal code and remove the space
1163: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city
1164: ,pad.country country
1165: FROM per_addresses pad
1166: WHERE pad.person_id=p_person_id
1167: AND p_effective_date between date_from AND NVL(date_to,hr_general.end_of_time)

Line 1167: AND p_effective_date between date_from AND NVL(date_to,hr_general.end_of_time)

1163: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city
1164: ,pad.country country
1165: FROM per_addresses pad
1166: WHERE pad.person_id=p_person_id
1167: AND p_effective_date between date_from AND NVL(date_to,hr_general.end_of_time)
1168: AND ((pad.primary_flag = 'Y' and p_address_type is null)
1169: or (p_address_type is not null and pad.address_type = p_address_type));
1170:
1171: BEGIN

Line 1211: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city

1207: ,pad.address_line1 address_line1
1208: ,pad.address_line2 address_line2
1209: ,pad.address_line3 address_line3
1210: ,get_postal_code_new(pad.postal_code) postcode --introduce a space at the 5th position if there isn't one
1211: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city
1212: ,pad.country country
1213: FROM per_addresses pad
1214: WHERE pad.person_id=p_person_id
1215: AND p_effective_date between date_from AND NVL(date_to,hr_general.end_of_time)

Line 1215: AND p_effective_date between date_from AND NVL(date_to,hr_general.end_of_time)

1211: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city
1212: ,pad.country country
1213: FROM per_addresses pad
1214: WHERE pad.person_id=p_person_id
1215: AND p_effective_date between date_from AND NVL(date_to,hr_general.end_of_time)
1216: AND ((pad.primary_flag = 'Y' and p_address_type is null)
1217: or (p_address_type is not null and pad.address_type = p_address_type));
1218:
1219: BEGIN

Line 1259: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city

1255: ,hlc.address_line_2 address_2
1256: ,hlc.address_line_3 address_3
1257: ,hlc.region_1 street_name
1258: ,get_postal_code(hlc.postal_code) postcode --get the postal code and remove the space
1259: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city
1260: ,hlc.country country
1261: FROM hr_locations hlc
1262: ,hr_organization_units hou
1263: WHERE hou.business_group_id = p_bg_id

Line 1309: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city

1305: ,hlc.address_line_2 address_2
1306: ,hlc.address_line_3 address_3
1307: ,hlc.region_1 street_name
1308: ,get_postal_code_new(hlc.postal_code) postcode --introduce a space at the 5th position if there isn't one
1309: ,hr_general.decode_lookup('HR_NL_CITY',hlc.town_or_city) city
1310: ,hlc.country country
1311: FROM hr_locations hlc
1312: ,hr_organization_units hou
1313: WHERE hou.business_group_id = p_bg_id