APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_EXT_RSLT_DTL

Line 1758: FROM ben_ext_rslt_dtl dtl

1754:
1755:
1756: CURSOR csr_get_ttl_rslt(c_ext_rslt_id IN Number) IS
1757: SELECT val_01,val_02,val_03,val_04,val_05
1758: FROM ben_ext_rslt_dtl dtl
1759: ,ben_ext_rcd rcd
1760: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1761: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1762: AND rcd.rcd_type_cd = 'T';

Line 1794: FROM ben_ext_rslt_dtl dtl

1790: CURSOR csr_get_ern_ttl_rslt(c_ext_rslt_id IN Number) IS
1791: SELECT val_01 payhcnt,
1792: nvl(val_03,0) + nvl(val_04,0) pearntot,
1793: nvl(val_02,0) + nvl(val_05,0) + nvl(val_06,0) + nvl(val_07,0) + nvl(val_08,0) + nvl(val_09,0) + nvl(val_10,0) + nvl(val_11,0) + nvl(val_12,0) pdedstot
1794: FROM ben_ext_rslt_dtl dtl
1795: ,ben_ext_rcd rcd
1796: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1797: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1798: AND rcd.rcd_type_cd = 'T';