DBA Data[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on HZ_PARTIES

Line 1075: l_party_name hz_parties.party_name%TYPE;

1071: x_error_code OUT NOCOPY NUMBER,
1072: x_error_mesg OUT NOCOPY VARCHAR2
1073: ) AS
1074:
1075: l_party_name hz_parties.party_name%TYPE;
1076: l_message VARCHAR2(1000);
1077: l_module_name VARCHAR2(200) := g_module_name || 'PAYEE_SSN';
1078:
1079: BEGIN

Line 1089: from hz_parties

1085:
1086: begin
1087: select party_name
1088: into l_party_name
1089: from hz_parties
1090: where party_id = p_payee_party_id;
1091: exception
1092: when others then
1093: l_party_name := null;

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

1681: ce_bank_accounts cba,
1682: hz_code_assignments hca
1683: where ipa.payment_id = p_payment_id
1684: and ipa.internal_bank_account_id = cba.bank_account_id(+)
1685: and hca.owner_table_name(+) = 'HZ_PARTIES'
1686: and hca.class_category(+) = 'RFC_IDENTIFIER'
1687: and hca.owner_table_id(+) = cba.bank_branch_id;
1688:
1689: IF l_rfc_id IS NULL THEN -- p_rfc_identifier should not be Empty