APPS.XNB_CMN_PVT dependencies on HZ_PARTIES

Line 1792: IF l_table_name = 'HZ_PARTIES' THEN

1788: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);
1789:
1790: END;
1791:
1792: IF l_table_name = 'HZ_PARTIES' THEN
1793:
1794: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', 'Inside IF l_table_name = hz_parties');
1795:
1796: BEGIN

Line 1794: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', 'Inside IF l_table_name = hz_parties');

1790: END;
1791:
1792: IF l_table_name = 'HZ_PARTIES' THEN
1793:
1794: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', 'Inside IF l_table_name = hz_parties');
1795:
1796: BEGIN
1797:
1798: SELECT c.account_number

Line 1801: hz_parties b,

1797:
1798: SELECT c.account_number
1799: BULK COLLECT INTO l_acc_num
1800: FROM hz_contact_points a,
1801: hz_parties b,
1802: hz_cust_accounts c
1803: WHERE a.contact_point_id = l_param_value
1804: AND a.owner_table_id = b.party_id
1805: AND b.party_id = c.party_id;

Line 1836: END IF; /* l_table_name = 'HZ_PARTIES' */

1832: END IF;
1833:
1834: END LOOP;
1835:
1836: END IF; /* l_table_name = 'HZ_PARTIES' */
1837:
1838: END IF; /* If l_event_name = EVENT_NAME */
1839:
1840: END publish_account_update;