DBA Data[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PER_ADDRESSES_V

Line 2905: FROM per_addresses_v

2901: SELECT decode (country
2902: ,'NL'
2903: ,'Y'
2904: ,'N')
2905: FROM per_addresses_v
2906: WHERE person_id = c_person_id
2907: AND c_effective_date BETWEEN date_from
2908: AND nvl (date_to
2909: ,hr_api.g_eot)

Line 2987: FROM per_addresses_v pad

2983: ,substr(pad.address_line3, 1, 35) glb_location --NL_GLB Location
2984: ,upper(pad.postal_code) postal --Postal Code
2985: ,pad.town_or_city city --City
2986: ,pad.add_information16 iso --NL_GLB ISO Country code
2987: FROM per_addresses_v pad
2988: WHERE pad.person_id = c_person_id
2989: AND pad.primary_flag = 'Y'
2990: AND c_effective_date BETWEEN pad.date_from
2991: AND nvl (pad.date_to