APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on BEN_EXT_RCD

Line 1617: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)

1613: Function get_total_add_cont
1614: Return varchar2 is
1615: --
1616: Cursor csr_get_total_add_cont
1617: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
1618: is
1619: select sum(dtl.val_10) total_value
1620: from ben_ext_rslt_dtl dtl
1621: --,ben_ext_rcd rcd

Line 1621: --,ben_ext_rcd rcd

1617: (p_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE)
1618: is
1619: select sum(dtl.val_10) total_value
1620: from ben_ext_rslt_dtl dtl
1621: --,ben_ext_rcd rcd
1622: where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
1623: and dtl.ext_rcd_id = p_ext_rcd_id;
1624: -- and rcd.rcd_type_cd = 'D';
1625:

Line 1629: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

1625:
1626: l_proc_name varchar2(60) := g_proc_name || 'get_total_add_cont';
1627: l_total_add_cont_value number := 0;
1628: l_total_add_cont varchar2(10);
1629: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
1630: --
1631: Begin
1632:
1633: --

Line 1639: -- get the ben_ext_rcd.ext_rcd_id

1635: --
1636: debug_enter(l_proc_name);
1637:
1638: -- 11.5.10_CU2: Performance fix :
1639: -- get the ben_ext_rcd.ext_rcd_id
1640: -- and use this one for next the cursor
1641: -- This will prevent FTS on the table.
1642:
1643: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id