APPS.HZ_CUSTOMER_INT dependencies on ZX_PARTY_TAX_PROFILE_INT

Line 3647: FROM zx_party_tax_profile_int zx_ptp

3643:
3644: /*Query to identify errored out Customers*/
3645:
3646: CURSOR error_parties IS SELECT intf_party_reference
3647: FROM zx_party_tax_profile_int zx_ptp
3648: WHERE request_id = p_request_id
3649: AND zx_ptp.intf_party_site_reference IS NULL
3650: AND NVL(zx_ptp.record_status,3) = 3;
3651:

Line 3655: FROM zx_party_tax_profile_int zx_ptp

3651:
3652: /*Query to identify errored out Addresses*/
3653:
3654: CURSOR error_sites IS SELECT intf_party_site_reference
3655: FROM zx_party_tax_profile_int zx_ptp
3656: WHERE request_id = p_request_id
3657: AND zx_ptp.intf_party_site_reference IS NOT NULL
3658: AND NVL(zx_ptp.record_status,3) = 3;
3659: l_request_id NUMBER;

Line 3873: FROM zx_party_tax_profile_int

3869:
3870: BEGIN
3871:
3872: SELECT request_id INTO l_request_id
3873: FROM zx_party_tax_profile_int
3874: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3875: FROM ra_customers_interface
3876: )
3877: AND ROWNUM = 1 ;

Line 3918: FROM zx_party_tax_profile_int

3914:
3915: BEGIN
3916:
3917: SELECT request_id INTO l_request_id
3918: FROM zx_party_tax_profile_int
3919: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3920: FROM ra_customers_interface
3921: )
3922: AND ROWNUM = 1 ;

Line 3954: FROM zx_party_tax_profile_int

3950:
3951: BEGIN
3952:
3953: SELECT request_id INTO l_request_id
3954: FROM zx_party_tax_profile_int
3955: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3956: FROM ra_customers_interface
3957: )
3958: AND ROWNUM = 1 ;

Line 3996: FROM zx_party_tax_profile_int

3992:
3993: BEGIN
3994:
3995: SELECT request_id INTO l_request_id
3996: FROM zx_party_tax_profile_int
3997: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3998: FROM ra_customers_interface
3999: )
4000: AND ROWNUM = 1 ;