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_COBRA_REQUIREMENTS dependencies on BEN_ACTY_BASE_RT_F

Line 3575: from ben_acty_base_rt_f abr

3571: abr.rt_mlt_cd,
3572: abr.parnt_chld_cd,
3573: abr.rcrrg_cd,
3574: abr.name
3575: from ben_acty_base_rt_f abr
3576: where abr.acty_base_rt_id=c_acty_base_rt_id
3577: and c_effective_date between abr.effective_start_date
3578: and abr.effective_end_date;
3579:

Line 3588: from ben_acty_base_rt_f abr,

3584: )
3585: is
3586: select abr2.rt_mlt_cd,
3587: abr2.entr_ann_val_flag
3588: from ben_acty_base_rt_f abr,
3589: ben_acty_base_rt_f abr2
3590: where abr.acty_base_rt_id = c_acty_base_rt_id
3591: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
3592: and abr2.parnt_chld_cd = 'PARNT'

Line 3589: ben_acty_base_rt_f abr2

3585: is
3586: select abr2.rt_mlt_cd,
3587: abr2.entr_ann_val_flag
3588: from ben_acty_base_rt_f abr,
3589: ben_acty_base_rt_f abr2
3590: where abr.acty_base_rt_id = c_acty_base_rt_id
3591: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
3592: and abr2.parnt_chld_cd = 'PARNT'
3593: and c_effective_date

Line 3928: ,ben_acty_base_rt_f i

3924: ,pay_element_types_f b
3925: ,pay_assignment_actions d
3926: ,pay_payroll_actions e
3927: ,pay_run_results h
3928: ,ben_acty_base_rt_f i
3929: ,pay_input_values_f j
3930: WHERE d.assignment_id = c_assignment_id
3931: AND d.payroll_action_id = e.payroll_action_id
3932: AND i.input_value_id = j.input_value_id

Line 4108: ,ben_acty_base_rt_f abr

4104: ,pen.prtt_enrt_rslt_id
4105: ,prv.mlt_cd
4106: FROM ben_prtt_enrt_rslt_f pen
4107: ,ben_prtt_rt_val prv
4108: ,ben_acty_base_rt_f abr
4109: WHERE pen.person_id = c_person_id
4110: AND pen.pgm_id = c_pgm_id
4111: AND pen.pl_typ_id = c_pl_typ_id
4112: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 4148: ,ben_acty_base_rt_f abr

4144: ,prv.mlt_cd
4145: ,abr.name
4146: FROM ben_prtt_enrt_rslt_f pen
4147: ,ben_prtt_rt_val prv
4148: ,ben_acty_base_rt_f abr
4149: WHERE pen.person_id = c_person_id
4150: AND pen.pgm_id = c_pgm_id
4151: AND pen.pl_typ_id = c_pl_typ_id
4152: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 4358: from ben_acty_base_rt_f abr,

4354: ,c_business_group_id in number
4355: ,c_effective_date in date
4356: ) is
4357: select entries.balance_adj_cost_flag
4358: from ben_acty_base_rt_f abr,
4359: pay_element_entry_values_f ee_values,
4360: pay_element_entries_f entries
4361: where abr.acty_base_rt_id = c_acty_base_rt_id
4362: and c_effective_date between abr.effective_start_date

Line 4380: from ben_acty_base_rt_f abr,

4376: ) is
4377: select elk.costable_type,
4378: link_inp_val.element_link_id,
4379: abr.input_value_id
4380: from ben_acty_base_rt_f abr,
4381: pay_input_values_f inp_val,
4382: pay_element_links_f elk,
4383: pay_link_input_values_f link_inp_val
4384: where acty_base_rt_id = c_acty_base_rt_id

Line 4469: ,ben_acty_base_rt_f abr

4465: ,abr.element_type_id
4466: ,abr.input_value_id
4467: FROM ben_prtt_enrt_rslt_f pen
4468: ,ben_prtt_rt_val prv
4469: ,ben_acty_base_rt_f abr
4470: WHERE pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
4471: AND c_effective_date BETWEEN pen.enrt_cvg_strt_dt
4472: AND pen.enrt_cvg_thru_dt
4473: AND pen.enrt_cvg_thru_dt <= pen.effective_end_date

Line 4505: ,ben_acty_base_rt_f i

4501: ,pay_element_types_f b
4502: ,pay_assignment_actions d
4503: ,pay_payroll_actions e
4504: ,pay_run_results h
4505: ,ben_acty_base_rt_f i
4506: ,pay_input_values_f j
4507: WHERE d.assignment_id = c_assignment_id
4508: AND d.payroll_action_id = e.payroll_action_id
4509: AND i.input_value_id = j.input_value_id

Line 4540: ,ben_acty_base_rt_f i

4536: ,pay_element_types_f b
4537: ,pay_assignment_actions d
4538: ,pay_payroll_actions e
4539: ,pay_run_results h
4540: ,ben_acty_base_rt_f i
4541: ,pay_input_values_f j
4542: WHERE d.assignment_id = c_assignment_id
4543: AND d.payroll_action_id = e.payroll_action_id
4544: AND i.input_value_id = j.input_value_id

Line 4578: ,ben_acty_base_rt_f i

4574: ,pay_element_types_f b
4575: ,pay_assignment_actions d
4576: ,pay_payroll_actions e
4577: ,pay_run_results h
4578: ,ben_acty_base_rt_f i
4579: ,pay_input_values_f j
4580: WHERE d.assignment_id = c_assignment_id
4581: AND d.payroll_action_id = e.payroll_action_id
4582: AND i.input_value_id = j.input_value_id

Line 4620: ,ben_acty_base_rt_f abr

4616: ,pen.prtt_enrt_rslt_id
4617: ,prv.mlt_cd
4618: FROM ben_prtt_enrt_rslt_f pen
4619: ,ben_prtt_rt_val prv
4620: ,ben_acty_base_rt_f abr
4621: WHERE pen.person_id = c_person_id
4622: AND pen.pgm_id = c_pgm_id
4623: AND pen.pl_typ_id = c_pl_typ_id
4624: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 4656: ,ben_acty_base_rt_f abr

4652: ,pen.prtt_enrt_rslt_id
4653: ,prv.mlt_cd
4654: FROM ben_prtt_enrt_rslt_f pen
4655: ,ben_prtt_rt_val prv
4656: ,ben_acty_base_rt_f abr
4657: WHERE pen.person_id = c_person_id
4658: AND pen.pgm_id = c_pgm_id
4659: AND pen.pl_typ_id = c_pl_typ_id
4660: AND pen.prtt_enrt_rslt_stat_cd IS NULL