APPS.QA_PLAN_ELEMENT_API dependencies on HZ_PARTIES

Line 1593: FROM hz_parties

1589: id NUMBER;
1590:
1591: CURSOR c (p_name VARCHAR2) IS
1592: SELECT party_id
1593: FROM hz_parties
1594: WHERE status = 'A'
1595: AND party_name = p_name
1596: AND party_type IN ('ORGANIZATION','PERSON')
1597: ORDER BY party_name;

Line 3957: FROM hz_parties

3953: /*
3954: --Reviewing 2255344. Incorrect SQL. bso
3955:
3956: sql_string := 'SELECT party_number, party_name
3957: FROM hz_parties
3958: WHERE party_number like :1
3959: AND status = ''A''
3960: AND party_type IN (''ORGANIZATION'',''PERSON'')
3961: ORDER BY party_name';

Line 3964: FROM hz_parties

3960: AND party_type IN (''ORGANIZATION'',''PERSON'')
3961: ORDER BY party_name';
3962: */
3963: sql_string := 'SELECT party_name, party_number
3964: FROM hz_parties
3965: WHERE party_name like :1
3966: AND status = ''A''
3967: AND party_type IN (''ORGANIZATION'',''PERSON'')
3968: ORDER BY party_name';