APPS.QA_PLAN_ELEMENT_API dependencies on HZ_PARTIES

Line 1574: FROM hz_parties

1570: id NUMBER;
1571:
1572: CURSOR c (p_name VARCHAR2) IS
1573: SELECT party_id
1574: FROM hz_parties
1575: WHERE status = 'A'
1576: AND party_name = p_name
1577: AND party_type IN ('ORGANIZATION','PERSON')
1578: ORDER BY party_name;

Line 3825: FROM hz_parties

3821: /*
3822: --Reviewing 2255344. Incorrect SQL. bso
3823:
3824: sql_string := 'SELECT party_number, party_name
3825: FROM hz_parties
3826: WHERE party_number like :1
3827: AND status = ''A''
3828: AND party_type IN (''ORGANIZATION'',''PERSON'')
3829: ORDER BY party_name';

Line 3832: FROM hz_parties

3828: AND party_type IN (''ORGANIZATION'',''PERSON'')
3829: ORDER BY party_name';
3830: */
3831: sql_string := 'SELECT party_name, party_number
3832: FROM hz_parties
3833: WHERE party_name like :1
3834: AND status = ''A''
3835: AND party_type IN (''ORGANIZATION'',''PERSON'')
3836: ORDER BY party_name';