DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_CUSTOMER_INT

Line 1: PACKAGE BODY hz_customer_int AS

1: PACKAGE BODY hz_customer_int AS
2: /*$Header: ARHCUSIB.pls 120.21.12010000.2 2008/10/17 13:02:45 idali ship $*/
3:
4: -- The following varibles and types are added for bug 2460837.
5:

Line 3510: WHERE hzp.party_id = HZ_CUSTOMER_INT.get_account_party_id(rci.orig_system_party_ref,rci.person_flag,'P')

3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID
3507: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3508: from ra_customers_interface_all rci, -- Bug 4956131
3509: hz_parties hzp
3510: WHERE hzp.party_id = HZ_CUSTOMER_INT.get_account_party_id(rci.orig_system_party_ref,rci.person_flag,'P')
3511: AND rci.request_id = p_request_id
3512: AND rci.interface_status is null
3513: AND rci.insert_update_flag = 'I'
3514: AND ( rci.rowid = (SELECT min(i2.rowid)

Line 3555: END hz_customer_int;

3551: to_date('31-12-4712','DD-MM-YYYY')
3552: )));
3553: END insert_nci_party_usages;
3554:
3555: END hz_customer_int;