APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on BEN_EXT_RCD

Line 1553: FROM ben_ext_rcd rcd,

1549: FUNCTION post_process_rule(p_ext_rslt_id IN NUMBER) RETURN VARCHAR2 IS
1550: --
1551: CURSOR get_asg_rcd_id IS
1552: SELECT rcd.ext_rcd_id
1553: FROM ben_ext_rcd rcd,
1554: ben_ext_rcd_in_file rif,
1555: ben_ext_dfn dfn,
1556: ben_ext_rslt rslt
1557: WHERE rslt.ext_rslt_id = p_ext_rslt_id

Line 1554: ben_ext_rcd_in_file rif,

1550: --
1551: CURSOR get_asg_rcd_id IS
1552: SELECT rcd.ext_rcd_id
1553: FROM ben_ext_rcd rcd,
1554: ben_ext_rcd_in_file rif,
1555: ben_ext_dfn dfn,
1556: ben_ext_rslt rslt
1557: WHERE rslt.ext_rslt_id = p_ext_rslt_id
1558: AND rslt.ext_dfn_id = dfn.ext_dfn_id

Line 1567: FROM ben_ext_rcd rcd,

1563: l_asg_rcd_id NUMBER;
1564: --
1565: CURSOR get_veh_rcd_id IS
1566: SELECT rcd.ext_rcd_id
1567: FROM ben_ext_rcd rcd,
1568: ben_ext_rcd_in_file rif,
1569: ben_ext_dfn dfn,
1570: ben_ext_rslt rslt
1571: WHERE rslt.ext_rslt_id = p_ext_rslt_id

Line 1568: ben_ext_rcd_in_file rif,

1564: --
1565: CURSOR get_veh_rcd_id IS
1566: SELECT rcd.ext_rcd_id
1567: FROM ben_ext_rcd rcd,
1568: ben_ext_rcd_in_file rif,
1569: ben_ext_dfn dfn,
1570: ben_ext_rslt rslt
1571: WHERE rslt.ext_rslt_id = p_ext_rslt_id
1572: AND rslt.ext_dfn_id = dfn.ext_dfn_id

Line 3190: FROM ben_ext_rcd rcd,

3186: FUNCTION post_process_rule_04(p_ext_rslt_id IN NUMBER) RETURN VARCHAR2 IS
3187: --
3188: CURSOR get_asg_rcd_id IS
3189: SELECT rcd.ext_rcd_id
3190: FROM ben_ext_rcd rcd,
3191: ben_ext_rcd_in_file rif,
3192: ben_ext_dfn dfn,
3193: ben_ext_rslt rslt
3194: WHERE rslt.ext_rslt_id = p_ext_rslt_id

Line 3191: ben_ext_rcd_in_file rif,

3187: --
3188: CURSOR get_asg_rcd_id IS
3189: SELECT rcd.ext_rcd_id
3190: FROM ben_ext_rcd rcd,
3191: ben_ext_rcd_in_file rif,
3192: ben_ext_dfn dfn,
3193: ben_ext_rslt rslt
3194: WHERE rslt.ext_rslt_id = p_ext_rslt_id
3195: AND rslt.ext_dfn_id = dfn.ext_dfn_id

Line 3204: FROM ben_ext_rcd rcd,

3200: l_asg_rcd_id NUMBER;
3201: --
3202: CURSOR get_veh_rcd_id IS
3203: SELECT rcd.ext_rcd_id
3204: FROM ben_ext_rcd rcd,
3205: ben_ext_rcd_in_file rif,
3206: ben_ext_dfn dfn,
3207: ben_ext_rslt rslt
3208: WHERE rslt.ext_rslt_id = p_ext_rslt_id

Line 3205: ben_ext_rcd_in_file rif,

3201: --
3202: CURSOR get_veh_rcd_id IS
3203: SELECT rcd.ext_rcd_id
3204: FROM ben_ext_rcd rcd,
3205: ben_ext_rcd_in_file rif,
3206: ben_ext_dfn dfn,
3207: ben_ext_rslt rslt
3208: WHERE rslt.ext_rslt_id = p_ext_rslt_id
3209: AND rslt.ext_dfn_id = dfn.ext_dfn_id