[Home] [Help]
21: x_return_status IN OUT NOCOPY VARCHAR2
22: ) RETURN VARCHAR2 IS
23: CURSOR c_country IS
24: SELECT org.home_country
25: FROM hz_organization_profiles org
26: WHERE org.party_id = p_bank_id
27: AND SYSDATE between TRUNC(effective_start_date)
28: and NVL(TRUNC(effective_end_date), SYSDATE+1);
29: l_country VARCHAR2(60);
68: hz_bankorg.home_country,
69: hz_bank.party_name,
70: hz_bankorg.bank_or_branch_number
71: FROM hz_parties hz_bank,
72: hz_organization_profiles hz_bankorg,
73: hz_parties hz_branch,
74: hz_relationships hz_rel,
75: hz_code_assignments hz_bankCA,
76: hz_code_assignments hz_branchCA
826: CURSOR c_bank_name IS
827: SELECT hz_hp.party_id,
828: hz_ca.end_date_active
829: FROM hz_parties hz_hp,
830: hz_organization_profiles hz_org,
831: hz_code_assignments hz_ca
832: WHERE hz_ca.owner_table_id = hz_hp.party_id
833: AND hz_ca.owner_table_name = 'HZ_PARTIES'
834: AND hz_ca.class_category = 'BANK_INSTITUTION_TYPE'
842: CURSOR c_bank_num IS
843: SELECT hz_hp.party_id,
844: hz_ca.end_date_active
845: FROM hz_parties hz_hp,
846: hz_organization_profiles hz_hop,
847: hz_code_assignments hz_ca
848: WHERE hz_hp.party_id = hz_hop.party_id
849: AND SYSDATE between TRUNC(hz_hop.effective_start_date)
850: and NVL(TRUNC(hz_hop.effective_end_date), SYSDATE+1)
971: ) IS
972: CURSOR c_bank IS
973: SELECT hz_p.party_name, hz_org.bank_or_branch_number
974: FROM hz_parties hz_p,
975: hz_organization_profiles hz_org
976: WHERE hz_p.party_id = hz_org.party_id
977: AND SYSDATE between TRUNC(hz_org.effective_start_date)
978: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)
979: AND hz_p.party_id = p_bank_id;
1813: CURSOR c_branch_num IS
1814: SELECT hz_branch.party_id,
1815: hz_branchCA.end_date_active
1816: FROM hz_parties hz_branch,
1817: hz_organization_profiles hz_branchProf,
1818: hz_relationships hz_rel,
1819: hz_code_assignments hz_branchCA
1820: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1821: AND hz_branchCA.owner_table_id = hz_branch.party_id
1914: FROM CE_BANK_ACCOUNTS
1915: WHERE bank_account_id = x_acct_id;
1916: CURSOR c_branch IS
1917: SELECT bank_or_branch_number
1918: FROM hz_organization_profiles
1919: WHERE SYSDATE between TRUNC(effective_start_date)
1920: and NVL(TRUNC(effective_end_date), SYSDATE+1)
1921: AND party_id = p_acct_rec.branch_id;
1922: /*
2350: WHERE bank_account_id = p_acct_rec.bank_account_id;
2351:
2352: CURSOR c_branch_num(l_branch_id NUMBER) IS
2353: SELECT bank_or_branch_number
2354: FROM hz_organization_profiles
2355: WHERE SYSDATE between TRUNC(effective_start_date)
2356: and NVL(TRUNC(effective_end_date), SYSDATE+1)
2357: AND party_id = l_branch_id;
2358: