DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PER_ADDRESSES

Line 3103: from per_addresses

3099: , region_1 ee_street_name
3100: , region_2 ee_suburb_district
3101: , town_or_city ee_town_city
3102: , postal_code ee_postal_code
3103: from per_addresses
3104: where person_id = p_person_id
3105: and l_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'))
3106: and style = p_address_style
3107: and address_type = p_address_type;

Line 3129: from per_addresses

3125: , decode(region_2,'Y',null,address_line1) ee_add_line1 -- if flag = Y, then don't populate remaining postal address fields
3126: , decode(region_2,'Y',null,address_line2) ee_add_line2
3127: , decode(region_2,'Y',null,address_line3) ee_add_line3
3128: , decode(region_2,'Y',null,postal_code) ee_postal_code
3129: from per_addresses
3130: where person_id = p_person_id
3131: and l_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'))
3132: and style = 'ZA'
3133: and primary_flag = 'Y';