APPS.POS_VENDOR_REG_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 989: FROM zx_party_tax_profile

985: l_user_id NUMBER;
986:
987: CURSOR l_ptp_cur(p_party_id IN NUMBER) IS
988: SELECT party_tax_profile_id
989: FROM zx_party_tax_profile
990: WHERE party_id = p_party_id
991: AND party_type_code = 'THIRD_PARTY'
992: AND ROWNUM = 1;
993:

Line 1109: zx_party_tax_profile_pkg.update_row

1105: FETCH l_ptp_cur INTO l_party_tax_profile_id;
1106: IF l_ptp_cur%found THEN
1107: CLOSE l_ptp_cur;
1108:
1109: zx_party_tax_profile_pkg.update_row
1110: (p_party_tax_profile_id => l_party_tax_profile_id,
1111: p_collecting_authority_flag => NULL,
1112: p_provider_type_code => NULL,
1113: p_create_awt_dists_type_code => NULL,

Line 1162: x_msg_data := 'call to zx_party_tax_profile_pkg.update_row failed';

1158: IF x_return_status IS NULL
1159: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1160: ROLLBACK TO approve_supplier_reg;
1161: x_msg_count := 1;
1162: x_msg_data := 'call to zx_party_tax_profile_pkg.update_row failed';
1163: RETURN;
1164: END IF;
1165: ELSE
1166: CLOSE l_ptp_cur;

Line 1856: FROM ap_suppliers pv, zx_party_tax_profile zxpr

1852: AND psr.registration_status = 'PENDING_APPROVAL';
1853:
1854: CURSOR po_vendors_cur IS
1855: SELECT pv.vendor_id
1856: FROM ap_suppliers pv, zx_party_tax_profile zxpr
1857: WHERE zxpr.party_id = pv.party_id
1858: AND zxpr.rep_registration_number = p_taxreg_num
1859: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR
1860: (p_country is null));

Line 1864: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr

1860: (p_country is null));
1861:
1862: CURSOR po_vendor_sites_cur IS
1863: SELECT pvsa.vendor_id
1864: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr
1865: WHERE zxpr.rep_registration_number = p_taxreg_num
1866: AND zxpr.site_flag = 'Y'
1867: AND zxpr.party_id = pvsa.party_site_id
1868: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR