[Home] [Help]
51: x_return_status IN OUT NOCOPY VARCHAR2
52: ) RETURN VARCHAR2 IS
53: CURSOR c_country IS
54: SELECT org.home_country
55: FROM hz_organization_profiles org
56: WHERE org.party_id = p_bank_id
57: AND SYSDATE between TRUNC(effective_start_date)
58: and NVL(TRUNC(effective_end_date), SYSDATE+1);
59: l_country VARCHAR2(60);
98: hz_bankorg.home_country,
99: hz_bank.party_name,
100: hz_bankorg.bank_or_branch_number
101: FROM hz_parties hz_bank,
102: hz_organization_profiles hz_bankorg,
103: hz_parties hz_branch,
104: hz_relationships hz_rel,
105: hz_code_assignments hz_bankCA,
106: hz_code_assignments hz_branchCA
850: CURSOR c_bank_name IS
851: SELECT hz_hp.party_id,
852: hz_ca.end_date_active
853: FROM hz_parties hz_hp,
854: hz_organization_profiles hz_org,
855: hz_code_assignments hz_ca
856: WHERE hz_ca.owner_table_id = hz_hp.party_id
857: AND hz_hp.party_type = 'ORGANIZATION' -- Bug 8333484
858: AND NVL(hz_hp.status, 'A') = 'A' -- Bug 8333484
868: CURSOR c_bank_num IS
869: SELECT hz_hp.party_id,
870: hz_ca.end_date_active
871: FROM hz_parties hz_hp,
872: hz_organization_profiles hz_hop,
873: hz_code_assignments hz_ca
874: WHERE hz_hp.party_id = hz_hop.party_id
875: AND hz_hp.party_type = 'ORGANIZATION' -- Bug 8333484
876: AND NVL(hz_hp.status, 'A') = 'A' -- Bug 8333484
999: ) IS
1000: CURSOR c_bank IS
1001: SELECT hz_p.party_name, hz_org.bank_or_branch_number
1002: FROM hz_parties hz_p,
1003: hz_organization_profiles hz_org
1004: WHERE hz_p.party_id = hz_org.party_id
1005: AND SYSDATE between TRUNC(hz_org.effective_start_date)
1006: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)
1007: AND hz_p.party_id = p_bank_id;
1952: CURSOR c_branch_num IS
1953: SELECT hz_branch.party_id,
1954: hz_branchCA.end_date_active
1955: FROM hz_parties hz_branch,
1956: hz_organization_profiles hz_branchProf,
1957: hz_relationships hz_rel,
1958: hz_code_assignments hz_branchCA
1959: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1960: AND hz_branchCA.owner_table_id = hz_branch.party_id
2053: FROM CE_BANK_ACCOUNTS
2054: WHERE bank_account_id = x_acct_id;
2055: CURSOR c_branch IS
2056: SELECT bank_or_branch_number
2057: FROM hz_organization_profiles
2058: WHERE SYSDATE between TRUNC(effective_start_date)
2059: and NVL(TRUNC(effective_end_date), SYSDATE+1)
2060: AND party_id = p_acct_rec.branch_id;
2061: /*
2628: WHERE bank_account_id = p_acct_rec.bank_account_id;
2629:
2630: CURSOR c_branch_num(l_branch_id NUMBER) IS
2631: SELECT bank_or_branch_number
2632: FROM hz_organization_profiles
2633: WHERE SYSDATE between TRUNC(effective_start_date)
2634: and NVL(TRUNC(effective_end_date), SYSDATE+1)
2635: AND party_id = l_branch_id;
2636: