DBA Data[Home] [Help]

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 3725: hz_person_profiles_s.nextval,

3721: DECEASED_FLAG,
3722: CREATED_BY_MODULE
3723: )
3724: select
3725: hz_person_profiles_s.nextval,
3726: PARTY_ID,
3727: decode(:l_person_name, NULL, PERSON_NAME, :G_MISS_CHAR, PERSON_NAME,
3728: :l_person_name),
3729: :l_sysdate,

Line 6206: hz_person_profiles_s.nextval,

6202: DECEASED_FLAG,
6203: CREATED_BY_MODULE
6204: )
6205: select
6206: hz_person_profiles_s.nextval,
6207: l_party_id(j),
6208: nvl(l_person_name(j), l_party_name(j)),
6209: P_DML_RECORD.SYSDATE,
6210: P_DML_RECORD.USER_ID,

Line 9123: hz_person_profiles_s.nextval,

9119: DECEASED_FLAG,
9120: CREATED_BY_MODULE
9121: )
9122: select
9123: hz_person_profiles_s.nextval,
9124: l_party_id(j),
9125: nvl(l_person_name(j), l_party_name(j)),
9126: P_DML_RECORD.SYSDATE,
9127: P_DML_RECORD.USER_ID,