eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AP_ACTG_POPULATE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 318: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile

314:
315: l_tbl_index_party BINARY_INTEGER;
316: l_tbl_index_site BINARY_INTEGER;
317:
318: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile
319:
320: CURSOR party_id_cur
321: (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS
322: SELECT party_id

Line 323: FROM zx_party_tax_profile

319:
320: CURSOR party_id_cur
321: (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS
322: SELECT party_id
323: FROM zx_party_tax_profile
324: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
325: AND party_type_code = 'THIRD_PARTY';
326:
327: CURSOR party_site_id_cur

Line 330: FROM zx_party_tax_profile

326:
327: CURSOR party_site_id_cur
328: (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS
329: SELECT party_id
330: FROM zx_party_tax_profile
331: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
332: AND party_type_code = 'THIRD_PARTY_SITE';
333: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
334:

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

329: SELECT party_id
330: FROM zx_party_tax_profile
331: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
332: AND party_type_code = 'THIRD_PARTY_SITE';
333: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
334:
335: CURSOR party_profile_id_cur
336: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
337: SELECT party_tax_profile_id

Line 338: FROM zx_party_tax_profile

334:
335: CURSOR party_profile_id_cur
336: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
337: SELECT party_tax_profile_id
338: FROM zx_party_tax_profile
339: WHERE party_id = c_bill_from_party_id
340: AND party_type_code = 'THIRD_PARTY';
341:
342: CURSOR site_profile_id_cur

Line 345: FROM zx_party_tax_profile

341:
342: CURSOR site_profile_id_cur
343: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
344: SELECT party_tax_profile_id
345: FROM zx_party_tax_profile
346: WHERE party_id = c_bill_from_site_id
347: AND party_type_code = 'THIRD_PARTY_SITE';
348:
349: CURSOR party_cur