DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on PER_ADDRESSES

Line 1099: from per_addresses addr

1095: ,addr.town_or_city Town_or_City
1096: ,decode(addr.country, 'CA', addr.region_1,
1097: 'US', addr.region_2, addr.region_1 ) Province
1098: ,addr.postal_code Postal_Code
1099: from per_addresses addr
1100: ,fnd_territories_vl country
1101: where addr.person_id = p_person_id
1102: and addr.primary_flag = 'Y'
1103: /* Added the trunc function by ssmukher for Bug 4205724 */