DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on HZ_PARTY_SITES

Line 1086: FROM hz_party_sites

1082: IS
1083: CURSOR c_party_site_id
1084: IS
1085: SELECT party_site_id
1086: FROM hz_party_sites
1087: WHERE party_site_id = p_party_site_id;
1088:
1089: CURSOR c_party_site_number
1090: IS

Line 1092: FROM hz_party_sites

1088:
1089: CURSOR c_party_site_number
1090: IS
1091: SELECT party_site_id
1092: FROM hz_party_sites
1093: WHERE party_site_number = p_party_site_number;
1094: BEGIN
1095: x_return_status := fnd_api.g_ret_sts_success;
1096:

Line 3535: FROM hz_party_sites

3531: CURSOR c_party_site(b_site_id number,
3532: b_party_id number)
3533: IS
3534: SELECT 'found'
3535: FROM hz_party_sites
3536: WHERE party_site_id = b_site_id
3537: AND party_id = b_party_id;
3538:
3539: CURSOR c_party_acct(b_acct_id number,