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_RATES

Line 299: FROM ben_cwb_person_rates rt

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
298: SELECT object_version_number
299: FROM ben_cwb_person_rates rt
300: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
301: AND rt.pl_id = v_pl_id
302: AND rt.oipl_id = v_oipl_id;
303:

Line 483: ben_cwb_person_rates

479: AND hrchy.lvl_num > 0)
480: )
481: and not exists(
482: select null from
483: ben_cwb_person_rates
484: where group_per_in_ler_id = pil.per_in_ler_id
485: )
486: and (v_business_group_id is null or
487: per.business_group_id = v_business_group_id)

Line 515: , ben_cwb_person_rates rates

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
519: AND pil.lf_evt_ocrd_dt = v_lf_evt_orcd_date

Line 552: from ben_cwb_person_rates

548:
549: CURSOR c_check_eligibility (v_group_per_in_ler_id IN NUMBER)
550: IS
551: select null
552: from ben_cwb_person_rates
553: where group_per_in_ler_id = v_group_per_in_ler_id
554: and oipl_id = -1
555: and elig_flag = 'Y';
556:

Line 644: FROM ben_cwb_person_rates rt

640:
641: CURSOR c_task_type (v_group_per_in_ler_id IN NUMBER)
642: IS
643: SELECT dsgn.ws_sub_acty_typ_cd
644: FROM ben_cwb_person_rates rt
645: , ben_cwb_pl_dsgn dsgn
646: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
647: AND rt.pl_id = dsgn.pl_id
648: AND rt.oipl_id = dsgn.oipl_id

Line 683: FROM ben_cwb_person_rates rt

679: ,v_profile_value in varchar2
680: )
681: IS
682: SELECT SUM (rt.ws_val)
683: FROM ben_cwb_person_rates rt
684: ,ben_oipl_f oipl
685: ,ben_opt_f opt
686: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
687: AND rt.group_pl_id = v_group_pl_id

Line 705: FROM ben_cwb_person_rates rt

701: ) IS
702: SELECT DECODE(v_rule_based,'Y',
703: min(WS_RT_START_DATE),
704: min(OVRID_RT_STRT_DT)) effective_date
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

Line 753: FROM ben_cwb_person_rates rt

749: , rt.elig_sal_val
750: , xchg.xchg_rate
751: , rt.elig_flag
752: , rt.currency
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

Line 813: FROM ben_cwb_person_rates rt

809: , xchg.xchg_rate
810: , rt.elig_flag
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

Line 1008: ,ben_cwb_person_rates r

1004: AND info.group_per_in_ler_id = pil.per_in_ler_id
1005: AND NOT EXISTS (
1006: SELECT NULL
1007: FROM ben_cwb_group_hrchy h, ben_per_in_ler p
1008: ,ben_cwb_person_rates r
1009: WHERE h.mgr_per_in_ler_id = pil.per_in_ler_id
1010: AND h.lvl_num > 0
1011: AND p.per_in_ler_id = h.emp_per_in_ler_id
1012: AND p.lf_evt_ocrd_dt = pil.lf_evt_ocrd_dt

Line 1206: FROM ben_cwb_person_rates rates

1202: FROM ben_transaction trans,
1203: ben_cwb_pl_dsgn dsgn
1204: WHERE trans.transaction_id IN
1205: (SELECT DISTINCT pl_id
1206: FROM ben_cwb_person_rates rates
1207: WHERE group_per_in_ler_id = v_group_per_in_ler_id)
1208: AND trans.transaction_type = 'CWBPPOVDT' || to_char(v_lf_evt_ocrd_dt,'yyyy/mm/dd');
1209:
1210: CURSOR c_slaves(v_request_id IN NUMBER)

Line 1226: FROM BEN_CWB_PERSON_RATES

1222: v_group_oipl_id IN NUMBER,
1223: v_lf_evt_ocrd_dt IN DATE)
1224: IS
1225: SELECT WS_RT_START_DATE
1226: FROM BEN_CWB_PERSON_RATES
1227: WHERE GROUP_PER_IN_LER_ID = v_group_per_in_ler_id
1228: AND PL_ID = v_pl_id
1229: AND OIPL_ID = v_oipl_id
1230: AND LF_EVT_OCRD_DT = v_lf_evt_ocrd_dt

Line 2845: ben_cwb_person_rates_api.update_person_rate

2841: INTO l_rate_ovn;
2842:
2843: CLOSE c_rate_ovn;
2844: write_m ('Time before updating the person rates with proposal and element entry ids '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
2845: ben_cwb_person_rates_api.update_person_rate
2846: (p_group_per_in_ler_id => p_group_per_in_ler_id
2847: , p_pl_id => sal_rate_rec.pl_id
2848: , p_oipl_id => sal_rate_rec.oipl_id
2849: , p_pay_proposal_id => l_pay_proposal_id

Line 3208: ben_cwb_person_rates_api.update_person_rate

3204: INTO l_rate_ovn;
3205:
3206: CLOSE c_rate_ovn;
3207: write_m ('Time before updating person rates '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
3208: ben_cwb_person_rates_api.update_person_rate
3209: (p_group_per_in_ler_id => p_group_per_in_ler_id
3210: , p_pl_id => p_pl_id
3211: , p_oipl_id => p_oipl_id
3212: --, p_element_entry_value_id => l_ele_ent_id

Line 3324: ben_cwb_person_rates_api.update_person_rate

3320:
3321: CLOSE c_rate_ovn;
3322: BEGIN
3323: IF(NOT l_error) THEN
3324: ben_cwb_person_rates_api.update_person_rate
3325: (p_group_per_in_ler_id => p_group_per_in_ler_id
3326: , p_pl_id => p_pl_id
3327: , p_oipl_id => p_oipl_id
3328: , p_element_entry_value_id => p_element_entry_value_id

Line 3922: ben_cwb_person_rates_api.update_person_rate

3918: write_h ('||p_oipl_id ' || rt_rec.oipl_id);
3919: write_h ('||p_comp_posting_date ' || l_effective_date);
3920: write_h ('||p_object_version_number ' || rt_rec.object_version_number);
3921: write_h ('================================================================');
3922: ben_cwb_person_rates_api.update_person_rate
3923: (p_group_per_in_ler_id => p_group_per_in_ler_id
3924: , p_pl_id => rt_rec.pl_id
3925: , p_oipl_id => rt_rec.oipl_id
3926: , p_comp_posting_date => l_effective_date