APPS.HZ_IMP_LOAD_PARTIES_PKG dependencies on HZ_PERSON_PROFILES_S

Line 1493: hz_person_profiles_s.nextval,

1489: :5, -- program_application_id
1490: :6, -- program_id
1491: :3, -- sysdate
1492: :7, -- request_id
1493: hz_person_profiles_s.nextval,
1494: party_id,
1495: person_name,
1496: person_pre_name_adjunct,
1497: person_first_name,

Line 1610: hz_person_profiles_s.nextval+1,

1606: :5, -- program_application_id
1607: :6, -- program_id
1608: :3, -- sysdate
1609: :7, -- request_id
1610: hz_person_profiles_s.nextval+1,
1611: party_id,
1612: person_name,
1613: person_pre_name_adjunct,
1614: person_first_name,

Line 1728: hz_person_profiles_s.nextval+2,

1724: :5, -- program_application_id
1725: :6, -- program_id
1726: :3, -- sysdate
1727: :7, -- request_id
1728: hz_person_profiles_s.nextval+2,
1729: party_id,
1730: person_name,
1731: person_pre_name_adjunct,
1732: person_first_name,

Line 3731: hz_person_profiles_s.nextval,

3727: DECEASED_FLAG,
3728: CREATED_BY_MODULE
3729: )
3730: select
3731: hz_person_profiles_s.nextval,
3732: PARTY_ID,
3733: decode(:l_person_name, NULL, PERSON_NAME, :G_MISS_CHAR, PERSON_NAME,
3734: :l_person_name),
3735: :l_sysdate,

Line 6224: hz_person_profiles_s.nextval,

6220: DECEASED_FLAG,
6221: CREATED_BY_MODULE
6222: )
6223: select
6224: hz_person_profiles_s.nextval,
6225: l_party_id(j),
6226: nvl(l_person_name(j), l_party_name(j)),
6227: P_DML_RECORD.SYSDATE,
6228: P_DML_RECORD.USER_ID,

Line 9141: hz_person_profiles_s.nextval,

9137: DECEASED_FLAG,
9138: CREATED_BY_MODULE
9139: )
9140: select
9141: hz_person_profiles_s.nextval,
9142: l_party_id(j),
9143: nvl(l_person_name(j), l_party_name(j)),
9144: P_DML_RECORD.SYSDATE,
9145: P_DML_RECORD.USER_ID,