APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on FND_TERRITORIES_TL

Line 48: directly to fnd_territories_tl. added where condition

44: added assignment_type = 'E' condition in
45: where clause, i.e. assignment is of type Employee
46: 29-DEC-03 jgoswami 115.8 3341291 modified the cursors for address which was
47: missing fnd_territories in sql and joining
48: directly to fnd_territories_tl. added where condition
49: for checking user language.
50: 05-JAN-04 ppanda 115.10 3141296 When Country code is not for the address code assumes its a US
51: address to set the per_addresses.region_2 as the state for
52: the employee address

Line 800: , fnd_territories_tl fttl

796: 'Y' valid_address
797: from per_all_assignments_f assign
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

Line 845: , fnd_territories_tl fttl

841: 'Y' valid_address
842: FROM per_all_assignments_f ASSIGN
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

Line 886: , fnd_territories_tl fttl

882: addr.region_2 ,
883: 'Y' valid_address
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

Line 927: , fnd_territories_tl fttl

923: addr.region_2 ,
924: 'Y' valid_address
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