APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on HR_LOOKUPS

Line 802: , hr_lookups hrt

798: , per_addresses addr
799: , per_all_people_f ppf
800: , fnd_territories_tl fttl
801: , fnd_territories ftt
802: , hr_lookups hrt
803: where ASSIGN.assignment_id = c_assignment_id
804: and c_effective_date BETWEEN ASSIGN.effective_start_date
805: AND ASSIGN.effective_end_date
806: and assign.person_id = ppf.person_id

Line 847: , hr_lookups hrt

843: , per_addresses ADDR
844: , per_all_people_f PPF
845: , fnd_territories_tl fttl
846: , fnd_territories ftt
847: , hr_lookups hrt
848: where ASSIGN.assignment_id = c_assignment_id
849: and ASSIGN.person_id = ppf.person_id
850: and assign.assignment_type = 'E'
851: and ADDR.person_id = ASSIGN.person_id

Line 888: , hr_lookups hrt

884: FROM per_addresses ADDR
885: , per_all_people_f PPF
886: , fnd_territories_tl fttl
887: , fnd_territories ftt
888: , hr_lookups hrt
889: where ppf.person_id = c_person_id
890: and c_effective_date BETWEEN ppf.effective_start_date
891: AND ppf.effective_end_date
892: and ADDR.person_id = ppf.person_id

Line 929: , hr_lookups hrt

925: FROM per_addresses addr
926: , per_all_people_f ppf
927: , fnd_territories_tl fttl
928: , fnd_territories ftt
929: , hr_lookups hrt
930: where ppf.person_id = c_person_id
931: and addr.person_id = ppf.person_id
932: and addr.primary_flag = 'Y'
933: and NVL(addr.country,'US') = ftt.territory_code

Line 1134: hr_lookups hrl,

1130: hl.region_2,
1131: hl.telephone_number_1,
1132: 'Y' valid_address
1133: FROM hr_locations_all hl,
1134: hr_lookups hrl,
1135: hr_all_organization_units hou
1136: WHERE hou.organization_id = c_organization_id
1137: AND hl.location_id = hou.location_id
1138: AND nvl(hl.inactive_date,end_date)>= c_effective_date