APPS.HZ_BANK_PUB dependencies on HZ_ORGANIZATION_PROFILES

Line 120: FROM hz_organization_profiles hop,

116: CURSOR c_parentinfo IS
117: SELECT hop.bank_or_branch_number,
118: hop.organization_name,
119: hop.home_country
120: FROM hz_organization_profiles hop,
121: hz_parties hp
122: WHERE hop.party_id = p_bank_id
123: AND SYSDATE BETWEEN TRUNC(hop.effective_start_date)
124: AND NVL(hop.effective_end_date, SYSDATE+1)

Line 133: FROM hz_organization_profiles hop,

129: SELECT hop.party_id,
130: hop.bank_or_branch_number,
131: hop.organization_name,
132: hop.home_country
133: FROM hz_organization_profiles hop,
134: hz_parties hp,
135: hz_relationships hr
136: WHERE hr.object_id = p_bank_rec.organization_rec.party_rec.party_id
137: AND hr.relationship_type = 'BANK_AND_BRANCH'

Line 156: hz_organization_profiles hopbb

152: p_parent_id NUMBER
153: ) IS
154: SELECT 1
155: FROM hz_relationships hr,
156: hz_organization_profiles hopbb
157: WHERE hr.subject_id = p_parent_id
158: AND hr.relationship_type = 'BANK_AND_BRANCH'
159: AND hr.relationship_code = 'HAS_BRANCH'
160: AND hr.subject_type = 'ORGANIZATION'

Line 477: from hz_organization_profiles

473: -- Bug 3814832
474: if p_bank_rec.organization_rec.home_country is null
475: then
476: select home_country into l_country
477: from hz_organization_profiles
478: where party_id=l_temp_id
479: and sysdate between trunc(effective_start_date)
480: and nvl(effective_end_date, sysdate+1);
481: else l_country:=p_bank_rec.organization_rec.home_country;

Line 1462: FROM hz_organization_profiles hop, hz_parties hp

1458: x_return_status IN OUT NOCOPY VARCHAR2
1459: ) IS
1460: CURSOR c_parentcountry (p_party_id IN NUMBER) IS
1461: SELECT hop.home_country
1462: FROM hz_organization_profiles hop, hz_parties hp
1463: WHERE hop.party_id = p_party_id
1464: AND hp.party_id = hop.party_id
1465: AND hp.status = 'A'
1466: AND sysdate between trunc(hop.effective_start_date)

Line 1650: | hz_organization_profiles_pkg.update_row |

1646: | Updates the organization profile record's bank organization and |
1647: | party-specific attributes. |
1648: | |
1649: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1650: | hz_organization_profiles_pkg.update_row |
1651: | |
1652: | MODIFICATION HISTORY |
1653: | 27-NOV-2001 J. del Callar Created. |
1654: | 25-APR-2002 J. del Callar Bug 2272311: Changed rowid cursor |

Line 1666: FROM hz_organization_profiles hop

1662: p_branch_code IN VARCHAR2
1663: ) IS
1664: CURSOR c_orgprof IS
1665: SELECT hop.ROWID
1666: FROM hz_organization_profiles hop
1667: WHERE hop.organization_profile_id = p_profile_id;
1668:
1669: l_orowid VARCHAR2(60);
1670: l_debug_prefix VARCHAR2(30);

Line 1705: hz_organization_profiles_pkg.update_row(

1701: p_prefix =>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_statement);
1703: END IF;
1704:
1705: hz_organization_profiles_pkg.update_row(
1706: x_rowid => l_orowid,
1707: x_organization_profile_id => NULL,
1708: x_party_id => NULL,
1709: x_organization_name => NULL,

Line 2752: | hz_organization_profiles_pkg.update_row |

2748: | |
2749: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2750: | hz_utility_v2pub.debug |
2751: | hz_party_v2pub.update_organization |
2752: | hz_organization_profiles_pkg.update_row |
2753: | |
2754: | ARGUMENTS |
2755: | IN: |
2756: | p_init_msg_list Initialize message stack if it is |