DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on FND_TERRITORIES_VL

Line 806: ,fnd_territories_vl country

802: ,decode(addr.country, 'CA', addr.region_1,
803: 'US', addr.region_2, addr.region_1 ) Province
804: ,addr.postal_code Postal_Code
805: from per_addresses addr
806: ,fnd_territories_vl country
807: where addr.person_id = p_person_id
808: and addr.primary_flag = 'Y'
809: /* Added the trunc function by ssmukher for Bug 4205724 */
810: and trunc(p_effective_date) between