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_POST_PROCESS dependencies on BEN_CWB_PERSON_INFO

Line 76: * is obtained ben_cwb_person_info

72: * 04-Jun-04 aprabhak 115.41 Corrected the threading issue.
73: * 04-Jun-04 aprabhak 115.42 Corrected the thread process name
74: * 29-Jun-04 aprabhak 115.43 Fixed the bug #3712169
75: * 30-Jun-04 aprabhak 115.44 bg_id passed to the assignment changes
76: * is obtained ben_cwb_person_info
77: * 06-Jul-04 aprabhak 115.45 Access Change Routine
78: * 09-Jul-04 aprabhak 115.46 Recent Sal Change Message Corrected
79: * 14-Jul-04 aprabhak 115.47 fixed the issues reported in drop 13
80: * 22-Jul-04 aprabhak 115.48 Fixed the caching issues in error report.

Line 293: FROM ben_cwb_person_info info

289:
290: CURSOR c_info_ovn (v_group_per_in_ler_id IN NUMBER)
291: IS
292: SELECT object_version_number
293: FROM ben_cwb_person_info info
294: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id;
295:
296: CURSOR c_rate_ovn (v_group_per_in_ler_id IN NUMBER, v_pl_id IN NUMBER, v_oipl_id IN NUMBER)
297: IS

Line 324: , ben_cwb_person_info info

320: SELECT bg.NAME
321: , per.full_name
322: , info.business_group_id
323: FROM per_business_groups_perf bg
324: , ben_cwb_person_info info
325: , per_all_people_f per
326: , ben_per_in_ler pil
327: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
328: AND bg.business_group_id = info.business_group_id

Line 343: FROM ben_cwb_person_info per

339: , per.employee_number
340: , per.assignment_id
341: , per.business_group_id
342: , per.legislation_code
343: FROM ben_cwb_person_info per
344: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id;
345:
346: CURSOR c_prior_assignment(v_group_per_in_ler_id IN NUMBER)
347: IS

Line 391: FROM ben_cwb_person_info per

387: , per.ass_attribute27
388: , per.ass_attribute28
389: , per.ass_attribute29
390: , per.ass_attribute30
391: FROM ben_cwb_person_info per
392: , per_jobs_tl job
393: , hr_all_positions_f_tl pos
394: , per_grades_tl grades
395: , pay_people_groups ppl_groups

Line 462: ben_cwb_person_info per,

458: , per.business_group_id
459: FROM
460: ben_per_in_ler pil,
461: ben_per_in_ler mgr_pil,
462: ben_cwb_person_info per,
463: ben_cwb_group_hrchy hrchy,
464: per_business_groups_perf bg
465: where pil.per_in_ler_stat_cd = 'STRTD'
466: AND pil.group_pl_id = per.group_pl_id

Line 514: , ben_cwb_person_info per

510: FROM ben_per_in_ler pil
511: , ben_per_in_ler mgr_pil
512: , ben_cwb_group_hrchy hrchy
513: , per_business_groups_perf bg
514: , ben_cwb_person_info per
515: , ben_cwb_person_rates rates
516: , ben_cwb_pl_dsgn dsgn
517: WHERE pil.per_in_ler_stat_cd = 'STRTD'
518: AND pil.group_pl_id = v_pl_id

Line 709: , ben_cwb_person_info info

705: FROM ben_cwb_person_rates rt
706: , ben_oipl_f oipl
707: , ben_cwb_pl_dsgn dsgn
708: , ben_opt_f opt
709: , ben_cwb_person_info info
710: , ben_per_in_ler pil
711: , ben_cwb_xchg xchg
712: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
713: AND rt.pl_id = dsgn.pl_id

Line 757: , ben_cwb_person_info info

753: FROM ben_cwb_person_rates rt
754: , ben_oipl_f oipl
755: , ben_cwb_pl_dsgn dsgn
756: , ben_opt_f opt
757: , ben_cwb_person_info info
758: , ben_per_in_ler pil
759: , ben_cwb_xchg xchg
760: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
761: AND rt.group_pl_id = v_group_pl_id

Line 815: , ben_cwb_person_info info

811: , info.fte_factor
812: , rt.currency
813: FROM ben_cwb_person_rates rt
814: , ben_cwb_pl_dsgn dsgn
815: , ben_cwb_person_info info
816: , ben_per_in_ler pil
817: , ben_oipl_f oipl
818: , ben_opt_f opt
819: , ben_cwb_xchg xchg

Line 845: , ben_cwb_person_info per

841: , xtra_info.assignment_id
842: , xtra_info.object_version_number
843: , xtra_info.assignment_extra_info_id
844: FROM per_assignment_extra_info xtra_info
845: , ben_cwb_person_info per
846: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
847: AND xtra_info.assignment_id = per.assignment_id
848: AND xtra_info.information_type = 'CWBRANK'
849: AND xtra_info.aei_information1 IS NOT NULL

Line 863: , ben_cwb_person_info per

859: , xtra_info.aei_information4
860: , xtra_info.assignment_id
861: , xtra_info.object_version_number
862: FROM per_assignment_extra_info xtra_info
863: , ben_cwb_person_info per
864: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
865: AND xtra_info.assignment_id = per.assignment_id
866: AND xtra_info.information_type = 'CWBRANK'
867: AND xtra_info.aei_information5 = fnd_date.date_to_canonical(v_eff_dt)

Line 880: , ben_cwb_person_info per

876: , ppp.object_version_number
877: FROM per_all_assignments_f asg
878: , per_pay_bases ppb
879: , per_pay_proposals ppp
880: , ben_cwb_person_info per
881: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
882: AND asg.assignment_id = per.assignment_id
883: AND v_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
884: AND ppb.pay_basis_id = asg.pay_basis_id

Line 898: , ben_cwb_person_info per

894: CURSOR c_future_pay_proposal (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
895: IS
896: SELECT ppp.proposed_salary_n
897: FROM per_pay_proposals ppp
898: , ben_cwb_person_info per
899: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
900: AND ppp.assignment_id = per.assignment_id
901: AND ppp.change_date > v_effective_date;
902:

Line 936: FROM ben_cwb_person_info per

932: , per.base_salary_currency
933: , initcap(base_salary_frequency) base_salary_frequency
934: , pay_annulization_factor
935: , fte_factor
936: FROM ben_cwb_person_info per
937: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id;
938:
939: CURSOR c_group_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
940: IS

Line 998: ,ben_cwb_person_info info

994: SELECT pil.per_in_ler_id
995: ,nvl(info.custom_name,info.full_name) full_name
996: FROM ben_per_in_ler pil
997: ,ben_cwb_person_groups pgroup
998: ,ben_cwb_person_info info
999: WHERE pil.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
1000: AND pil.group_pl_id = v_group_pl_id
1001: AND pgroup.group_per_in_ler_id = pil.per_in_ler_id
1002: AND pgroup.group_oipl_id = -1

Line 1054: ben_cwb_person_info info

1050: dsgn.uom_precision,
1051: info.pay_annulization_factor,
1052: dsgn.salary_change_reason
1053: FROM ben_cwb_pl_dsgn dsgn,
1054: ben_cwb_person_info info
1055: WHERE dsgn.group_pl_id = v_group_pl_id
1056: AND dsgn.group_pl_id = dsgn.pl_id
1057: AND dsgn.oipl_id = -1
1058: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt

Line 1238: from ben_cwb_person_info

1234:
1235: CURSOR c_assgn_perf_rating_prcd(
1236: v_group_per_in_ler_id IN NUMBER) is
1237: select new_assgn_ovn, new_perf_event_id, new_perf_review_id
1238: from ben_cwb_person_info
1239: where group_per_in_ler_id = v_group_per_in_ler_id;
1240:
1241: --
1242: -- ============================================================================

Line 2438: ben_cwb_person_info_api.update_person_info

2434: INTO l_info_ovn;
2435: CLOSE c_info_ovn;
2436:
2437: WRITE ('updating post process stat code...');
2438: ben_cwb_person_info_api.update_person_info
2439: (p_group_per_in_ler_id => p_group_per_in_ler_id
2440: , p_post_process_stat_cd => 'PR'
2441: , p_object_version_number => l_info_ovn.object_version_number
2442: );