APPS.PQP_HRTCA_INTEGRATION dependencies on HZ_PARTIES

Line 2006: FROM hz_parties hzp

2002: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_OSSPerDtls';
2003: --
2004: CURSOR hz_pe (c_party_id IN Number) IS
2005: SELECT hzp.party_number
2006: FROM hz_parties hzp
2007: WHERE hzp.party_id = c_party_id;
2008: BEGIN
2009: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2010: SAVEPOINT oss_per_dtls;

Line 2852: AND hcp.owner_table_name = 'HZ_PARTIES'

2848: ,hcp.phone_line_type
2849: FROM hz_contact_points hcp
2850: WHERE hcp.contact_point_type = 'PHONE'
2851: AND hcp.status = 'A'
2852: AND hcp.owner_table_name = 'HZ_PARTIES'
2853: AND hcp.owner_table_id = c_party_id;
2854:
2855: TYPE t_Phones IS TABLE OF hz_contact_points.phone_number%TYPE
2856: INDEX BY Binary_Integer;