APPS.BEN_CWB_ASG_UPDATE dependencies on BEN_CWB_PERSON_INFO

Line 26: * 115.7 29-Mar-2004 maagrawa Update ben_cwb_person_info with perf/promo

22: * friendly BEN error.
23: * 115.5 12-Jan-2004 maagrawa Global Budgeting Change.
24: * 115.6 25-Mar-2004 maagrawa Add a general message before the errors
25: * received from HR apis for SS.
26: * 115.7 29-Mar-2004 maagrawa Update ben_cwb_person_info with perf/promo
27: * ids when called from PP.
28: * 115.8 25-May-2004 maagrawa Splitting of perf/promo record and have
29: * them floating across plans.
30: * 115.9 01-Jul-2004 maagrawa Do not validate data in online mode.(Temp)

Line 168: from ben_cwb_person_info inf

164: cursor c_per_in_ler is
165: select inf.group_per_in_ler_id
166: ,inf.group_pl_id pl_id
167: ,inf.lf_evt_ocrd_dt
168: from ben_cwb_person_info inf
169: ,ben_cwb_pl_dsgn pl
170: where inf.assignment_id = p_txn_old.transaction_id
171: and inf.group_pl_id = p_group_pl_id
172: and inf.group_pl_id = pl.pl_id

Line 329: from ben_cwb_person_info inf

325: cursor c_per_in_ler is
326: select inf.group_per_in_ler_id
327: ,inf.group_pl_id pl_id
328: ,inf.lf_evt_ocrd_dt
329: from ben_cwb_person_info inf
330: ,ben_cwb_pl_dsgn pl
331: where inf.assignment_id = p_txn_old.transaction_id
332: and inf.group_pl_id = p_group_pl_id
333: and inf.group_pl_id = pl.pl_id

Line 2597: update ben_cwb_person_info

2593:
2594: --
2595: if p_group_per_in_ler_id is not null then
2596: --
2597: update ben_cwb_person_info
2598: set new_perf_event_id = l_update_event_id,
2599: new_perf_review_id = l_update_review_id
2600: where group_per_in_ler_id = p_group_per_in_ler_id;
2601: --

Line 2851: update ben_cwb_person_info

2847: end if;
2848: --
2849: if p_group_per_in_ler_id is not null and l_update_done then
2850: --
2851: update ben_cwb_person_info
2852: set new_assgn_ovn = l_asg_rec.object_version_number
2853: where group_per_in_ler_id = p_group_per_in_ler_id;
2854: --
2855: end if;