DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_PERSON_PROFILES_S

Line 2679: hz_person_profiles sst,

2675: nvl(i.cust_tax_reference, per.tax_reference),
2676: i.cust_tax_reference,
2677: decode(sst.tax_reference, '', 'Y', 'N'),nvl(per.version_number,1)+1
2678: FROM hz_person_profiles per,
2679: hz_person_profiles sst,
2680: ra_customers_interface_all i, -- Bug 4956131
2681: hz_cust_accounts cust,
2682: (SELECT min(i1.rowid) myrowid
2683: FROM ra_customers_interface_all i1 -- Bug 4956131

Line 2894: hz_person_profiles_s.nextval,

2890: 'USER_ENTERED',
2891: 'USER_ENTERED',
2892: 'TCA-CUSTOMER-INTERFACE',
2893: 222,
2894: hz_person_profiles_s.nextval,
2895: i_party_id(i),
2896: SYSDATE,
2897: 1,
2898: i_jgzz_fiscal_code(i),