DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_EXT_RCD

Line 1759: ,ben_ext_rcd rcd

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';
1763:

Line 1795: ,ben_ext_rcd rcd

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';
1799: