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 319: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile

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

Line 324: FROM zx_party_tax_profile

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

Line 331: FROM zx_party_tax_profile

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

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

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

Line 339: FROM zx_party_tax_profile

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

Line 346: FROM zx_party_tax_profile

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