APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 2156: FROM zx_party_tax_profile

2152:
2153: CURSOR party_id_cur
2154: (c_ptp_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_TAX_PROF_ID%TYPE) IS
2155: SELECT party_id
2156: FROM zx_party_tax_profile
2157: WHERE PARTY_TAX_PROFILE_ID = c_ptp_id
2158: AND party_type_code = 'THIRD_PARTY';
2159:
2160: CURSOR party_site_id_cur

Line 2163: FROM zx_party_tax_profile

2159:
2160: CURSOR party_site_id_cur
2161: (c_ptp_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_SITE_TAX_PROF_ID%TYPE) IS
2162: SELECT party_id
2163: FROM zx_party_tax_profile
2164: WHERE PARTY_TAX_PROFILE_ID = c_ptp_site_id
2165: AND party_type_code = 'THIRD_PARTY_SITE';
2166:
2167: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile

Line 2167: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile

2163: FROM zx_party_tax_profile
2164: WHERE PARTY_TAX_PROFILE_ID = c_ptp_site_id
2165: AND party_type_code = 'THIRD_PARTY_SITE';
2166:
2167: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
2168:
2169: CURSOR party_profile_id_cur
2170: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2171: SELECT party_tax_profile_id

Line 2172: FROM zx_party_tax_profile

2168:
2169: CURSOR party_profile_id_cur
2170: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2171: SELECT party_tax_profile_id
2172: FROM zx_party_tax_profile
2173: WHERE party_id = c_party_id
2174: AND party_type_code = 'THIRD_PARTY';
2175:
2176:

Line 2180: FROM zx_party_tax_profile

2176:
2177: CURSOR site_profile_id_cur
2178: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2179: SELECT party_tax_profile_id
2180: FROM zx_party_tax_profile
2181: WHERE party_id = c_party_site_id
2182: AND party_type_code = 'THIRD_PARTY_SITE';
2183:
2184: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

Line 2625: FROM zx_party_tax_profile

2621:
2622: CURSOR party_id_from_ptp_cur
2623: (c_ptp_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_TAX_PROF_ID%TYPE) IS
2624: SELECT party_id
2625: FROM zx_party_tax_profile
2626: WHERE PARTY_TAX_PROFILE_ID = c_ptp_id
2627: AND party_type_code = 'THIRD_PARTY';
2628:
2629: CURSOR party_site_id_from_ptp_cur

Line 2632: FROM zx_party_tax_profile

2628:
2629: CURSOR party_site_id_from_ptp_cur
2630: (c_ptp_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_SITE_TAX_PROF_ID%TYPE) IS
2631: SELECT party_id
2632: FROM zx_party_tax_profile
2633: WHERE PARTY_TAX_PROFILE_ID = c_ptp_site_id
2634: AND party_type_code = 'THIRD_PARTY_SITE';
2635:
2636: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile

Line 2636: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile

2632: FROM zx_party_tax_profile
2633: WHERE PARTY_TAX_PROFILE_ID = c_ptp_site_id
2634: AND party_type_code = 'THIRD_PARTY_SITE';
2635:
2636: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
2637:
2638: CURSOR party_profile_id_cur
2639: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2640: SELECT party_tax_profile_id

Line 2641: FROM zx_party_tax_profile

2637:
2638: CURSOR party_profile_id_cur
2639: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2640: SELECT party_tax_profile_id
2641: FROM zx_party_tax_profile
2642: WHERE party_id = c_party_id
2643: AND party_type_code = 'THIRD_PARTY';
2644:
2645:

Line 2649: FROM zx_party_tax_profile

2645:
2646: CURSOR site_profile_id_cur
2647: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2648: SELECT party_tax_profile_id
2649: FROM zx_party_tax_profile
2650: WHERE party_id = c_party_site_id
2651: AND party_type_code = 'THIRD_PARTY_SITE';
2652:
2653: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS