APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PER_ADDRESSES

Line 3358: FROM per_addresses

3354: DECODE(add_information14,NULL,NULL,','||add_information14)||
3355: DECODE(hr_general.decode_lookup('IN_STATES',add_information15),NULL,NULL,','||hr_general.decode_lookup('IN_STATES',add_information15))||
3356: DECODE(postal_code,NULL,NULL,','||postal_code)
3357: ,1,240) address
3358: FROM per_addresses
3359: WHERE person_id=p_person_id
3360: AND address_type='HK_R'
3361: AND p_effective_date BETWEEN date_from AND nvl(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
3362: