APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on BEN_EXT_RSLT

Line 1359: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id

1355: null;
1356:
1357: hr_utility.set_location('l_bal_return returned: '||l_bal_return,8);
1358:
1359: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
1360: ,p_ext_rslt_id => g_ext_rslt_id
1361: ,p_ext_rcd_id => g_veh_rcd_id
1362: ,p_person_id => g_person_id
1363: ,p_business_group_id => g_bg_id

Line 1751: ben_ext_rslt rslt

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
1754: AND dfn.ext_file_id = rif.ext_file_id
1755: AND rif.ext_rcd_id = rcd.ext_rcd_id

Line 1767: ben_ext_rslt rslt

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
1770: AND dfn.ext_file_id = rif.ext_file_id
1771: AND rif.ext_rcd_id = rcd.ext_rcd_id

Line 1779: FROM ben_ext_rslt_dtl

1775: --
1776: --
1777: CURSOR csr_ext_asg IS
1778: SELECT person_id, val_01 asg_id, ext_rslt_dtl_id, object_version_number
1779: FROM ben_ext_rslt_dtl
1780: WHERE ext_rslt_id = p_ext_rslt_id
1781: AND ext_rcd_id = l_asg_rcd_id;
1782: --
1783: l_obj_no NUMBER := NULL;

Line 1787: FROM ben_ext_rslt_dtl

1783: l_obj_no NUMBER := NULL;
1784: --
1785: CURSOR csr_balance_detail(p_person_id IN NUMBER) IS
1786: SELECT *
1787: FROM ben_ext_rslt_dtl
1788: WHERE ext_rslt_id = p_ext_rslt_id
1789: AND ext_rcd_id = g_veh_rcd_id
1790: AND person_id = p_person_id;
1791: --

Line 1845: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,

1841: THEN
1842: -- Primary assignment does not qualify for extract
1843: -- Delete this detail record
1844: hr_utility.trace('Primary asg does not qualify for extract - deleting detail record');
1845: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,
1846: p_object_version_number => l_balance_detail.object_version_number);
1847:
1848:
1849: ELSIF l_asg_include = 'Y' THEN

Line 1856: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,

1852: process_motorcycle_04(ext_asg_rec.asg_id);
1853: process_pedal_cycle_04(ext_asg_rec.asg_id);
1854: hr_utility.trace('First l_balance_detail.ext_rslt_dtl_id: '||l_balance_detail.ext_rslt_dtl_id);
1855:
1856: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,
1857: p_object_version_number => l_balance_detail.object_version_number);
1858:
1859:
1860: END IF;

Line 1874: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,

1870: l_obj_no := ext_asg_rec.object_version_number;
1871:
1872: -- Delete this assignment details record
1873: hr_utility.trace('This is not needed ext_asg_rec.ext_rslt_dtl_id: '||ext_asg_rec.ext_rslt_dtl_id);
1874: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
1875: p_object_version_number => l_obj_no);
1876:
1877: --
1878: END LOOP;