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 157: hz_organization_profiles hopbb

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

Line 489: from hz_organization_profiles

485: -- Bug 3814832
486: if p_bank_rec.organization_rec.home_country is null
487: then
488: select home_country into l_country
489: from hz_organization_profiles
490: where party_id=l_temp_id
491: and sysdate between trunc(effective_start_date)
492: and nvl(effective_end_date, sysdate+1);
493: else l_country:=p_bank_rec.organization_rec.home_country;

Line 1474: FROM hz_organization_profiles hop, hz_parties hp

1470: x_return_status IN OUT NOCOPY VARCHAR2
1471: ) IS
1472: CURSOR c_parentcountry (p_party_id IN NUMBER) IS
1473: SELECT hop.home_country
1474: FROM hz_organization_profiles hop, hz_parties hp
1475: WHERE hop.party_id = p_party_id
1476: AND hp.party_id = hop.party_id
1477: AND hp.status = 'A'
1478: AND sysdate between trunc(hop.effective_start_date)

Line 1662: | hz_organization_profiles_pkg.update_row |

1658: | Updates the organization profile record's bank organization and |
1659: | party-specific attributes. |
1660: | |
1661: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1662: | hz_organization_profiles_pkg.update_row |
1663: | |
1664: | MODIFICATION HISTORY |
1665: | 27-NOV-2001 J. del Callar Created. |
1666: | 25-APR-2002 J. del Callar Bug 2272311: Changed rowid cursor |

Line 1678: FROM hz_organization_profiles hop

1674: p_branch_code IN VARCHAR2
1675: ) IS
1676: CURSOR c_orgprof IS
1677: SELECT hop.ROWID
1678: FROM hz_organization_profiles hop
1679: WHERE hop.organization_profile_id = p_profile_id;
1680:
1681: l_orowid VARCHAR2(60);
1682: l_debug_prefix VARCHAR2(30);

Line 1717: hz_organization_profiles_pkg.update_row(

1713: p_prefix =>l_debug_prefix,
1714: p_msg_level=>fnd_log.level_statement);
1715: END IF;
1716:
1717: hz_organization_profiles_pkg.update_row(
1718: x_rowid => l_orowid,
1719: x_organization_profile_id => NULL,
1720: x_party_id => NULL,
1721: x_organization_name => NULL,

Line 2767: | hz_organization_profiles_pkg.update_row |

2763: | |
2764: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
2765: | hz_utility_v2pub.debug |
2766: | hz_party_v2pub.update_organization |
2767: | hz_organization_profiles_pkg.update_row |
2768: | |
2769: | ARGUMENTS |
2770: | IN: |
2771: | p_init_msg_list Initialize message stack if it is |