APPS.BEN_RECN_REP dependencies on BEN_PRTT_RT_VAL

Line 471: from ben_prtt_rt_val

467: ben_recn_rep.get_new_rates(pen.prtt_enrt_rslt_id,p_report_start_date,p_run_date,p_business_group_id,'RATE',pen.per_in_ler_id) lf_rate,
468: ben_recn_rep.get_new_rates(pen.prtt_enrt_rslt_id,p_report_start_date,p_run_date,p_business_group_id,'ELEMENT',pen.per_in_ler_id ) lf_elem_val
469: /*,
470: ( select sum(cmcd_rt_val)
471: from ben_prtt_rt_val
472: where prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id) lf_rate ,
473: ( select sum(screen_entry_value)
474: from ben_prtt_rt_val prv
475: ,pay_element_entry_values_f env

Line 474: from ben_prtt_rt_val prv

470: ( select sum(cmcd_rt_val)
471: from ben_prtt_rt_val
472: where prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id) lf_rate ,
473: ( select sum(screen_entry_value)
474: from ben_prtt_rt_val prv
475: ,pay_element_entry_values_f env
476: where prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
477: and env.element_entry_value_id = prv.element_entry_value_id) lf_elem_val */
478: from ben_prtt_enrt_rslt_f pen,

Line 1472: from ben_prtt_rt_val prv

1468: and popl.business_group_id = p_business_group_id;
1469: --
1470: cursor c_rate(c_prtt_enrt_rslt_id number) is
1471: select sum(prv.cmcd_rt_val)
1472: from ben_prtt_rt_val prv
1473: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1474: and tx_typ_cd in ('PRETAX' , 'AFTERTAX' , 'NOTAPPLICABLE')
1475: and acty_typ_cd in ('EEPYC','ERC', 'ERPYC')
1476: and add_months(last_day(p_report_start_date),-1) between rt_strt_dt and rt_end_dt;

Line 1542: from ben_prtt_rt_val prv

1538: ) RETURN NUMBER is
1539: --
1540: cursor c_rate(c_prtt_enrt_rslt_id number) is
1541: select sum(prv.cmcd_rt_val)
1542: from ben_prtt_rt_val prv
1543: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1544: and tx_typ_cd in ('PRETAX' , 'AFTERTAX' , 'NOTAPPLICABLE' )
1545: and acty_typ_cd in ('EEPYC','ERC' , 'ERPYC' )
1546: and prv.per_in_ler_id = p_per_in_ler_id;

Line 1552: from ben_prtt_rt_val prv,

1548: --and p_run_date between rt_strt_dt and rt_end_dt;
1549: --
1550: cursor c_total_elem_entry(c_prtt_enrt_rslt_id number) is
1551: select sum(screen_entry_value)
1552: from ben_prtt_rt_val prv,
1553: pay_element_entry_values_f env
1554: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1555: and env.element_entry_value_id = prv.element_entry_value_id
1556: and tx_typ_cd in ('PRETAX' , 'AFTERTAX' , 'NOTAPPLICABLE' )

Line 1602: from ben_prtt_rt_val prv

1598: ) RETURN date is
1599: --
1600: cursor c_rate(c_prtt_enrt_rslt_id number) is
1601: select min(prv.rt_strt_dt)
1602: from ben_prtt_rt_val prv
1603: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1604: and tx_typ_cd in ('PRETAX' , 'AFTERTAX')
1605: and acty_typ_cd in ('EEPYC','ERC') ;
1606: --and p_report_start_date <= rate_strt_dt;

Line 1639: from ben_prtt_rt_val prv,

1635: ) RETURN NUMBER is
1636: --
1637: cursor c_element_val is
1638: select sum(env.screen_entry_value)
1639: from ben_prtt_rt_val prv,
1640: pay_element_entry_values_f env
1641: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1642: and (p_tx_typ_cd is null or prv.tx_typ_cd = p_tx_typ_cd)
1643: and prv.acty_typ_cd = p_acty_typ_cd

Line 1656: from ben_prtt_rt_val prv,

1652: );-- 3608119
1653: --
1654: cursor c_er_element_val is
1655: select sum(env.screen_entry_value)
1656: from ben_prtt_rt_val prv,
1657: pay_element_entry_values_f env
1658: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1659: and (p_tx_typ_cd is null or prv.tx_typ_cd = p_tx_typ_cd)
1660: and prv.acty_typ_cd in ('ERC' , 'ERPYC' )

Line 1706: from ben_prtt_rt_val prv

1702: ) RETURN NUMBER is
1703: --
1704: cursor c_rate_val is
1705: select sum(prv.cmcd_rt_val)
1706: from ben_prtt_rt_val prv
1707: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1708: and (p_tx_typ_cd is null or prv.tx_typ_cd = p_tx_typ_cd)
1709: and prv.acty_typ_cd = p_acty_typ_cd
1710: and prv.per_in_ler_id = p_per_in_ler_id

Line 1718: from ben_prtt_rt_val prv

1714: )-- 3608119
1715: ;
1716: cursor c_er_rate_val is
1717: select sum(prv.cmcd_rt_val)
1718: from ben_prtt_rt_val prv
1719: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1720: and (p_tx_typ_cd is null or prv.tx_typ_cd = p_tx_typ_cd)
1721: and prv.acty_typ_cd in ('ERC' , 'ERPYC' )
1722: and prv.per_in_ler_id = p_per_in_ler_id

Line 1759: from ben_prtt_rt_val prv

1755: ) RETURN NUMBER is
1756: --
1757: cursor c_prtt_defn_amt is
1758: select sum(rt_val) rate
1759: from ben_prtt_rt_val prv
1760: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1761: and tx_typ_cd in ('PRETAX' , 'AFTERTAX', 'NOTAPPLICABLE')
1762: and acty_typ_cd in ('EEPYC','ERC')
1763: and prv.per_in_ler_id = p_per_in_ler_id