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 683: , fnd_territories_tl fttl

679: 'Y' valid_address
680: from per_all_assignments_f assign
681: , per_addresses addr
682: , per_all_people_f ppf
683: , fnd_territories_tl fttl
684: , fnd_territories ftt
685: , hr_lookups hrt
686: where ASSIGN.assignment_id = c_assignment_id
687: and c_effective_date BETWEEN ASSIGN.effective_start_date

Line 728: , fnd_territories_tl fttl

724: 'Y' valid_address
725: FROM per_all_assignments_f ASSIGN
726: , per_addresses ADDR
727: , per_all_people_f PPF
728: , fnd_territories_tl fttl
729: , fnd_territories ftt
730: , hr_lookups hrt
731: where ASSIGN.assignment_id = c_assignment_id
732: and ASSIGN.person_id = ppf.person_id

Line 769: , fnd_territories_tl fttl

765: addr.region_2 ,
766: 'Y' valid_address
767: FROM per_addresses ADDR
768: , per_all_people_f PPF
769: , fnd_territories_tl fttl
770: , fnd_territories ftt
771: , hr_lookups hrt
772: where ppf.person_id = c_person_id
773: and c_effective_date BETWEEN ppf.effective_start_date

Line 810: , fnd_territories_tl fttl

806: addr.region_2 ,
807: 'Y' valid_address
808: FROM per_addresses addr
809: , per_all_people_f ppf
810: , fnd_territories_tl fttl
811: , fnd_territories ftt
812: , hr_lookups hrt
813: where ppf.person_id = c_person_id
814: and addr.person_id = ppf.person_id