APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PER_ADDRESSES

Line 3146: FROM per_addresses

3142: DECODE(add_information14,NULL,NULL,','||add_information14)||
3143: DECODE(hr_general.decode_lookup('IN_STATES',add_information15),NULL,NULL,','||hr_general.decode_lookup('IN_STATES',add_information15))||
3144: DECODE(postal_code,NULL,NULL,','||postal_code)
3145: ,1,240) address
3146: FROM per_addresses
3147: WHERE person_id=p_person_id
3148: AND address_type='HK_R'
3149: AND p_effective_date BETWEEN date_from AND nvl(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
3150: