APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on BEN_EXT_RCD

Line 1637: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

1633: Function get_total_add_cont
1634: Return varchar2 is
1635: --
1636: Cursor csr_get_total_add_cont
1637: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
1638: is
1639: select sum(dtl.val_10) total_value
1640: from ben_ext_rslt_dtl dtl
1641: --,ben_ext_rcd rcd

Line 1641: --,ben_ext_rcd rcd

1637: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
1638: is
1639: select sum(dtl.val_10) total_value
1640: from ben_ext_rslt_dtl dtl
1641: --,ben_ext_rcd rcd
1642: where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
1643: and dtl.ext_rcd_id = p_ext_rcd_id;
1644: -- and rcd.rcd_type_cd = 'D';
1645:

Line 1649: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

1645:
1646: l_proc_name varchar2(60) := g_proc_name || 'get_total_add_cont';
1647: l_total_add_cont_value number := 0;
1648: l_total_add_cont varchar2(10);
1649: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
1650: --
1651: Begin
1652:
1653: --

Line 1659: -- get the ben_ext_rcd.ext_rcd_id

1655: --
1656: debug_enter(l_proc_name);
1657:
1658: -- 11.5.10_CU2: Performance fix :
1659: -- get the ben_ext_rcd.ext_rcd_id
1660: -- and use this one for next the cursor
1661: -- This will prevent FTS on the table.
1662:
1663: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id