DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PER_CONTACT_RELATIONSHIPS

Line 2968: FROM per_contact_relationships con,

2964: -- bug 13359530
2965: cursor cur_next_of_kin_details(l_termination_date date) is
2966: SELECT DISTINCT pa.ADDRESS_LINE1 address_line1,pa.ADDRESS_LINE2 address_line2,
2967: pa.ADDRESS_LINE3 address_line3,paf2.LAST_NAME last_name
2968: FROM per_contact_relationships con,
2969: PER_ALL_PEOPLE_F paf1,
2970: PER_ALL_PEOPLE_F paf2,
2971: fnd_lookup_values c ,
2972: per_addresses pa ,