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.AMS_EVHRULES_PVT dependencies on HZ_PARTY_SITES

Line 1672: l_party_site_id NUMBER; --primary party_site_id for the party_id from hz_party_sites table.

1668: )
1669: IS
1670: l_seq NUMBER; --Next value for the primary key in the import lead interface table.
1671: l_party_type VARCHAR2(30); --party_type for the p_party_id.
1672: l_party_site_id NUMBER; --primary party_site_id for the party_id from hz_party_sites table.
1673:
1674: CURSOR c_rec_id IS --Cursor to pick up the next value in the sequence.
1675: SELECT as_import_interface_s.NEXTVAL
1676: FROM DUAL;

Line 1687: FROM hz_party_sites

1683:
1684: --Cursor to pick up the data from HZ_PARTIE_SITES table.
1685: CURSOR c_party_site_info (party_id_in IN NUMBER) IS
1686: SELECT party_site_id
1687: FROM hz_party_sites
1688: WHERE party_id = party_id_in
1689: AND identifying_address_flag = 'Y';
1690:
1691: BEGIN