DBA Data[Home] [Help]

APPS.IGW_REPORT_PROCESSING dependencies on HZ_PARTIES

Line 1334: l_org_party_name hz_parties.party_name%TYPE;

1330: END;
1331: -------------------------------------------------------------------------------
1332:
1333: FUNCTION get_org_party_name(p_party_id in number, p_org_id in number) RETURN VARCHAR2 is
1334: l_org_party_name hz_parties.party_name%TYPE;
1335: begin
1336: if p_party_id is not null then
1337: select party_name
1338: into l_org_party_name

Line 1339: from hz_parties

1335: begin
1336: if p_party_id is not null then
1337: select party_name
1338: into l_org_party_name
1339: from hz_parties
1340: where party_id = p_party_id
1341: and party_type = 'ORGANIZATION';
1342: elsif p_org_id is not null then
1343: select name