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.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 1658: zx_party_tax_profile ptp

1654: SELECT reg.registration_number
1655: INTO l_state_inscription
1656: FROM zx_registrations reg,
1657: xle_etb_profiles etb,
1658: zx_party_tax_profile ptp
1659: WHERE etb.legal_entity_id = g_legal_entity_id
1660: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.
1661: AND TRUNC(g_start_date) >= TRUNC(NVL(main_effective_from,SYSDATE)) -- conditions to check establishment is active as main estb
1662: AND TRUNC(g_end_date) <= TRUNC(NVL(main_effective_to,SYSDATE))

Line 1684: zx_party_tax_profile ptp

1680: SELECT reg.registration_number
1681: INTO l_municipal_inscription
1682: FROM zx_registrations reg,
1683: xle_etb_profiles etb,
1684: zx_party_tax_profile ptp
1685: WHERE etb.legal_entity_id = g_legal_entity_id
1686: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.
1687: AND TRUNC(g_start_date) >= TRUNC(NVL(main_effective_from,SYSDATE)) -- conditions to check establishment is active as main estb
1688: AND TRUNC(g_end_date) <= TRUNC(NVL(main_effective_to,SYSDATE))

Line 1812: zx_party_tax_profile ptp

1808: SELECT reg.registration_number
1809: INTO l_state_inscription
1810: FROM zx_registrations reg,
1811: xle_etb_profiles etb,
1812: zx_party_tax_profile ptp
1813: WHERE etb.legal_entity_id = g_legal_entity_id
1814: AND etb.establishment_id = g_establishment_id
1815: AND etb.party_id = ptp.party_id
1816: AND ptp.party_tax_profile_id = reg.party_tax_profile_id

Line 1836: zx_party_tax_profile ptp

1832: SELECT reg.registration_number
1833: INTO l_municipal_inscription
1834: FROM zx_registrations reg,
1835: xle_etb_profiles etb,
1836: zx_party_tax_profile ptp
1837: WHERE etb.legal_entity_id = g_legal_entity_id
1838: AND etb.establishment_id = g_establishment_id
1839: AND etb.party_id = ptp.party_id
1840: AND ptp.party_tax_profile_id = reg.party_tax_profile_id

Line 2337: zx_party_tax_profile ptp

2333: SELECT reg.registration_number
2334: INTO l_state_inscription
2335: FROM zx_registrations reg,
2336: xle_etb_profiles etb,
2337: zx_party_tax_profile ptp
2338: WHERE etb.legal_entity_id = g_legal_entity_id
2339: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.
2340: AND TRUNC(g_start_date) >= TRUNC(NVL(main_effective_from,SYSDATE)) -- conditions to check establishment is active as main estb
2341: AND TRUNC(g_end_date) <= TRUNC(NVL(main_effective_to,SYSDATE))

Line 2363: zx_party_tax_profile ptp

2359: SELECT reg.registration_number
2360: INTO l_municipal_inscription
2361: FROM zx_registrations reg,
2362: xle_etb_profiles etb,
2363: zx_party_tax_profile ptp
2364: WHERE etb.legal_entity_id = g_legal_entity_id
2365: AND main_establishment_flag = 'Y' -- will fetch the registration number of main establishment for LE in case of EBtax.
2366: AND TRUNC(g_start_date) >= TRUNC(NVL(main_effective_from,SYSDATE)) -- conditions to check establishment is active as main estb
2367: AND TRUNC(g_end_date) <= TRUNC(NVL(main_effective_to,SYSDATE))

Line 2624: zx_party_tax_profile ptp

2620: SELECT reg.registration_number
2621: INTO l_state_inscription
2622: FROM zx_registrations reg,
2623: xle_etb_profiles etb,
2624: zx_party_tax_profile ptp
2625: WHERE etb.legal_entity_id = g_legal_entity_id
2626: AND etb.establishment_id = l_establishment_id -- will fetch the registration number of main establishment for LE in case of EBtax.
2627: AND etb.party_id = ptp.party_id
2628: AND ptp.party_tax_profile_id = reg.party_tax_profile_id

Line 2648: zx_party_tax_profile ptp

2644: SELECT reg.registration_number
2645: INTO l_municipal_inscription
2646: FROM zx_registrations reg,
2647: xle_etb_profiles etb,
2648: zx_party_tax_profile ptp
2649: WHERE etb.legal_entity_id = g_legal_entity_id
2650: AND etb.establishment_id = l_establishment_id -- will fetch the registration number of main establishment for LE in case of EBtax.
2651: AND etb.party_id = ptp.party_id
2652: AND ptp.party_tax_profile_id = reg.party_tax_profile_id