DBA Data[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on HZ_PARTIES

Line 1068: l_party_name hz_parties.party_name%TYPE;

1064: x_error_code OUT NOCOPY NUMBER,
1065: x_error_mesg OUT NOCOPY VARCHAR2
1066: ) AS
1067:
1068: l_party_name hz_parties.party_name%TYPE;
1069: l_message VARCHAR2(1000);
1070: l_module_name VARCHAR2(200) := g_module_name || 'PAYEE_SSN';
1071:
1072: BEGIN

Line 1082: from hz_parties

1078:
1079: begin
1080: select party_name
1081: into l_party_name
1082: from hz_parties
1083: where party_id = p_payee_party_id;
1084: exception
1085: when others then
1086: l_party_name := null;

Line 1672: and hca.owner_table_name(+) = 'HZ_PARTIES'

1668: ce_bank_accounts cba,
1669: hz_code_assignments hca
1670: where ipa.payment_id = p_payment_id
1671: and ipa.internal_bank_account_id = cba.bank_account_id(+)
1672: and hca.owner_table_name(+) = 'HZ_PARTIES'
1673: and hca.class_category(+) = 'RFC_IDENTIFIER'
1674: and hca.owner_table_id(+) = cba.bank_branch_id;
1675:
1676: IF l_rfc_id IS NULL THEN -- p_rfc_identifier should not be Empty