DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on BEN_EXT_RCD

Line 1748: FROM ben_ext_rcd rcd,

1744: FUNCTION post_process_rule(p_ext_rslt_id IN NUMBER) RETURN VARCHAR2 IS
1745:
1746: CURSOR csr_asg_record_id IS
1747: SELECT rcd.ext_rcd_id
1748: FROM ben_ext_rcd rcd,
1749: ben_ext_rcd_in_file rif,
1750: ben_ext_dfn dfn,
1751: ben_ext_rslt rslt
1752: WHERE rslt.ext_rslt_id = p_ext_rslt_id

Line 1749: ben_ext_rcd_in_file rif,

1745:
1746: CURSOR csr_asg_record_id IS
1747: SELECT rcd.ext_rcd_id
1748: FROM ben_ext_rcd rcd,
1749: ben_ext_rcd_in_file rif,
1750: ben_ext_dfn dfn,
1751: ben_ext_rslt rslt
1752: WHERE rslt.ext_rslt_id = p_ext_rslt_id
1753: AND rslt.ext_dfn_id = dfn.ext_dfn_id

Line 1764: FROM ben_ext_rcd rcd,

1760: l_asg_rcd_id NUMBER;
1761: --
1762: CURSOR csr_detail_record_id IS
1763: SELECT rcd.ext_rcd_id
1764: FROM ben_ext_rcd rcd,
1765: ben_ext_rcd_in_file rif,
1766: ben_ext_dfn dfn,
1767: ben_ext_rslt rslt
1768: WHERE rslt.ext_rslt_id = p_ext_rslt_id

Line 1765: ben_ext_rcd_in_file rif,

1761: --
1762: CURSOR csr_detail_record_id IS
1763: SELECT rcd.ext_rcd_id
1764: FROM ben_ext_rcd rcd,
1765: ben_ext_rcd_in_file rif,
1766: ben_ext_dfn dfn,
1767: ben_ext_rslt rslt
1768: WHERE rslt.ext_rslt_id = p_ext_rslt_id
1769: AND rslt.ext_dfn_id = dfn.ext_dfn_id