APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_EXT_RSLT_DTL

Line 1694: FROM ben_ext_rslt_dtl dtl

1690:
1691:
1692: CURSOR csr_get_ttl_rslt(c_ext_rslt_id IN Number) IS
1693: SELECT val_01,val_02,val_03,val_04,val_05
1694: FROM ben_ext_rslt_dtl dtl
1695: ,ben_ext_rcd rcd
1696: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1697: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1698: AND rcd.rcd_type_cd = 'T';

Line 1730: FROM ben_ext_rslt_dtl dtl

1726: CURSOR csr_get_ern_ttl_rslt(c_ext_rslt_id IN Number) IS
1727: SELECT val_01 payhcnt,
1728: nvl(val_03,0) + nvl(val_04,0) pearntot,
1729: 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
1730: FROM ben_ext_rslt_dtl dtl
1731: ,ben_ext_rcd rcd
1732: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1733: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1734: AND rcd.rcd_type_cd = 'T';