DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on PER_ALL_PEOPLE_F

Line 304: FROM per_all_people_f

300:
301: FORALL i1 in 1 .. ip_intf_id_upd2.count
302: UPDATE csi_i_party_interface cpi
303: SET cpi.party_id = (SELECT person_id
304: FROM per_all_people_f
305: WHERE full_name = cpi.party_name)
306: WHERE ip_interface_id=ip_intf_id_upd2(i1)
307: AND cpi.party_id IS NULL
308: AND cpi.party_name IS NOT NULL;

Line 829: FROM per_all_people_f

825:
826: FORALL i1 in 1 .. ip_intf_id_upd2.count
827: UPDATE csi_i_party_interface cpi
828: SET cpi.party_id = (SELECT person_id
829: FROM per_all_people_f
830: WHERE full_name = cpi.party_name)
831: WHERE ip_interface_id=ip_intf_id_upd2(i1)
832: AND cpi.party_id IS NULL
833: AND cpi.party_name IS NOT NULL;

Line 1167: FROM per_all_people_f

1163: AND cpi.party_name IS NOT NULL;
1164:
1165: UPDATE CSI_I_PARTY_INTERFACE cpi
1166: SET party_id = (SELECT person_id
1167: FROM per_all_people_f
1168: WHERE full_name = cpi.party_name)
1169: WHERE cpi.inst_interface_id IN (SELECT inst_interface_id
1170: FROM csi_instance_interface cii
1171: WHERE cii.transaction_identifier = p_txn_identifier)