eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_CWB_PERSON_INFO

Line 135: FROM ben_cwb_person_info info

131:
132: CURSOR c_info_ovn (v_group_per_in_ler_id IN NUMBER)
133: IS
134: SELECT object_version_number
135: FROM ben_cwb_person_info info
136: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id;
137:
138: CURSOR c_rate_ovn (v_group_per_in_ler_id IN NUMBER, v_pl_id IN NUMBER, v_oipl_id IN NUMBER)
139: IS

Line 160: ,ben_cwb_person_info per

156: ,per.full_name
157: ,per.person_id
158: ,per.group_per_in_ler_id
159: FROM ben_cwb_person_groups grp
160: ,ben_cwb_person_info per
161: WHERE grp.group_per_in_ler_id = v_group_per_in_ler_id
162: AND grp.group_pl_id = v_group_pl_id
163: AND grp.group_oipl_id = v_group_oipl_id
164: AND per.group_per_in_ler_id = grp.group_per_in_ler_id;

Line 172: , ben_cwb_person_info info

168: SELECT bg.NAME
169: , per.full_name
170: , info.business_group_id
171: FROM per_business_groups_perf bg
172: , ben_cwb_person_info info
173: , per_all_people_f per
174: , ben_per_in_ler pil
175: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
176: AND bg.business_group_id = info.business_group_id

Line 191: FROM ben_cwb_person_info per

187: , per.employee_number
188: , per.assignment_id
189: , per.business_group_id
190: , per.legislation_code
191: FROM ben_cwb_person_info per
192: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id;
193:
194: CURSOR c_batch_proc_info (v_benefit_action_id IN NUMBER)
195: IS

Line 252: , ben_cwb_person_info per

248: FROM ben_per_in_ler pil
249: , ben_per_in_ler mgr_pil
250: , ben_cwb_group_hrchy hrchy
251: , per_business_groups_perf bg
252: , ben_cwb_person_info per
253: , ben_cwb_person_rates rates
254: , ben_cwb_pl_dsgn dsgn
255: WHERE pil.per_in_ler_stat_cd = 'PROCD'
256: AND pil.group_pl_id = v_pl_id

Line 308: ben_cwb_person_info per,

304: , per.business_group_id
305: FROM
306: ben_per_in_ler pil,
307: ben_per_in_ler mgr_pil,
308: ben_cwb_person_info per,
309: ben_cwb_group_hrchy hrchy,
310: per_business_groups_perf bg
311: where pil.per_in_ler_stat_cd = 'PROCD'
312: AND pil.group_pl_id = per.group_pl_id

Line 359: , ben_cwb_person_info per

355: --, ben_per_in_ler mgr_pil
356: , ben_cwb_group_hrchy hrchy
357: --, ben_cwb_group_hrchy mgr_hrchy
358: , per_business_groups_perf bg
359: , ben_cwb_person_info per
360: , ben_cwb_person_info mgr_per
361: --, ben_cwb_person_rates rates
362: --, ben_cwb_pl_dsgn dsgn
363: WHERE pil.per_in_ler_stat_cd = 'PROCD'

Line 360: , ben_cwb_person_info mgr_per

356: , ben_cwb_group_hrchy hrchy
357: --, ben_cwb_group_hrchy mgr_hrchy
358: , per_business_groups_perf bg
359: , ben_cwb_person_info per
360: , ben_cwb_person_info mgr_per
361: --, ben_cwb_person_rates rates
362: --, ben_cwb_pl_dsgn dsgn
363: WHERE pil.per_in_ler_stat_cd = 'PROCD'
364: AND pil.group_pl_id = v_pl_id

Line 499: , ben_cwb_person_info per

495: , xtra_info.assignment_id
496: , xtra_info.object_version_number
497: , xtra_info.assignment_extra_info_id
498: FROM per_assignment_extra_info xtra_info
499: , ben_cwb_person_info per
500: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
501: AND xtra_info.assignment_id = per.assignment_id
502: AND xtra_info.information_type = 'CWBRANK'
503: AND xtra_info.aei_information1 IS NOT NULL

Line 519: , ben_cwb_person_info per

515: , xtra_info.aei_information4
516: , xtra_info.assignment_id
517: , xtra_info.object_version_number
518: FROM per_assignment_extra_info xtra_info
519: , ben_cwb_person_info per
520: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
521: AND xtra_info.assignment_id = per.assignment_id
522: AND xtra_info.information_type = 'CWBRANK'
523: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_eff_dt)

Line 550: , ben_cwb_person_info per

546: , ppp.object_version_number
547: FROM per_all_assignments_f asg
548: , per_pay_bases ppb
549: , per_pay_proposals ppp
550: , ben_cwb_person_info per
551: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
552: AND asg.assignment_id = per.assignment_id
553: AND v_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
554: AND ppb.pay_basis_id = asg.pay_basis_id

Line 568: , ben_cwb_person_info per

564: CURSOR c_future_pay_proposal (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
565: IS
566: SELECT ppp.proposed_salary_n
567: FROM per_pay_proposals ppp
568: , ben_cwb_person_info per
569: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
570: AND ppp.assignment_id = per.assignment_id
571: AND ppp.change_date > v_effective_date
572: AND ppp.approved='Y'; -- Bug 12635353

Line 583: FROM ben_cwb_person_info per

579: , initcap(base_salary_frequency) base_salary_frequency
580: , pay_annulization_factor
581: , fte_factor
582: , per.assignment_id
583: FROM ben_cwb_person_info per
584: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id;
585:
586: CURSOR c_group_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
587: IS

Line 721: , ben_cwb_person_info info

717: FROM ben_cwb_person_rates rt
718: , ben_oipl_f oipl
719: , ben_cwb_pl_dsgn dsgn
720: , ben_opt_f opt
721: , ben_cwb_person_info info
722: , ben_per_in_ler pil
723: , ben_cwb_xchg xchg
724: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
725: AND rt.group_pl_id = v_group_pl_id

Line 781: , ben_cwb_person_info info

777: , rt.currency
778: , rt.comp_posting_date
779: FROM ben_cwb_person_rates rt
780: , ben_cwb_pl_dsgn dsgn
781: , ben_cwb_person_info info
782: , ben_per_in_ler pil
783: , ben_oipl_f oipl
784: , ben_opt_f opt
785: , ben_cwb_xchg xchg

Line 837: ben_cwb_person_info info

833: dsgn.uom_precision,
834: info.pay_annulization_factor,
835: dsgn.salary_change_reason
836: FROM ben_cwb_pl_dsgn dsgn,
837: ben_cwb_person_info info
838: WHERE dsgn.group_pl_id = v_group_pl_id
839: AND dsgn.group_pl_id = dsgn.pl_id
840: AND dsgn.oipl_id = -1
841: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt

Line 992: ,ben_cwb_person_info per

988: ,per.person_id
989: ,per.group_per_in_ler_id
990: ,pl.name plan_name
991: FROM ben_cwb_pl_dsgn pl
992: ,ben_cwb_person_info per
993: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
994: and per.group_pl_id = pl.pl_id
995: and pl.oipl_id = -1;
996:

Line 2019: ben_cwb_person_info_api.update_person_info

2015: INTO l_info_ovn;
2016: CLOSE c_info_ovn;
2017:
2018: WRITE ('updating post process stat code...');
2019: ben_cwb_person_info_api.update_person_info
2020: (p_group_per_in_ler_id => p_group_per_in_ler_id
2021: , p_post_process_stat_cd => null
2022: , p_object_version_number => l_info_ovn.object_version_number
2023: );

Line 2409: ben_cwb_person_info info,

2405: rates.ws_val,
2406: per_saladmin_utility.get_pay_annualization_factor(info.assignment_id,rates.comp_posting_date,null,'PERIOD') pay_annual_ftr,
2407: dsgn.pl_annulization_factor plan_pay_annual_ftr --12714771
2408: from ben_cwb_person_rates rates,
2409: ben_cwb_person_info info,
2410: ben_cwb_pl_dsgn dsgn
2411: where rates.group_per_in_ler_id = p_per_in_ler_id
2412: and rates.pl_id = l_pl_id
2413: and rates.oipl_id = l_oipl_id

Line 2442: from ben_cwb_person_info

2438: --***************audit changes***************--
2439: --
2440: cursor c_cwb_person_info is
2441: select object_version_number
2442: from ben_cwb_person_info
2443: where group_per_in_ler_id = p_per_in_ler_id;
2444:
2445: cursor c_plan_salary is
2446: select

Line 2451: ,ben_cwb_person_info per

2447: nvl(plRt.ws_val,0) ws_val
2448: from
2449: ben_cwb_pl_dsgn pl
2450: ,ben_cwb_person_rates plRt
2451: ,ben_cwb_person_info per
2452: where plRt.group_per_in_ler_id = p_per_in_ler_id
2453: and plRt.group_per_in_ler_id = per.group_per_in_ler_id
2454: and plRt.pl_id = pl.pl_id
2455: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt

Line 2468: ,ben_cwb_person_info per

2464: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max
2465: from
2466: ben_cwb_pl_dsgn pl
2467: ,ben_cwb_person_rates plRt
2468: ,ben_cwb_person_info per
2469: where plRt.group_per_in_ler_id = p_per_in_ler_id
2470: and plRt.group_per_in_ler_id = per.group_per_in_ler_id
2471: and plRt.pl_id = pl.pl_id
2472: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt

Line 2482: ,ben_cwb_person_info per

2478: nvl(optRt.ws_val,0) ws_val
2479: from
2480: ben_cwb_pl_dsgn pl
2481: ,ben_cwb_person_rates optRt
2482: ,ben_cwb_person_info per
2483: where optRt.group_per_in_ler_id = p_per_in_ler_id
2484: and optRt.group_per_in_ler_id = per.group_per_in_ler_id
2485: and optRt.pl_id = pl.pl_id
2486: and optRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt

Line 2862: update ben_cwb_person_info

2858:
2859: --
2860: if p_group_per_in_ler_id is not null then
2861: --
2862: update ben_cwb_person_info
2863: set new_perf_event_id = l_update_event_id,
2864: new_perf_review_id = l_update_review_id
2865: where group_per_in_ler_id = p_group_per_in_ler_id;
2866: --