eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on BEN_EXT_RSLT

Line 1189: FROM ben_ext_rslt_dtl

1185: l_object_version_no NUMBER;
1186: --
1187: CURSOR chk_exists IS
1188: SELECT ext_rslt_dtl_id
1189: FROM ben_ext_rslt_dtl
1190: WHERE ext_rslt_id = g_ext_rslt_id
1191: AND person_id = g_person_id
1192: AND ext_rcd_id = g_veh_rcd_id
1193: AND val_02 = to_char(p_asg_id)

Line 1229: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id

1225: -- Record does not exist
1226: -- Call API to create extract details record
1227: BEGIN
1228: hr_utility.trace('CREATE_EXT_RSLT_DTL: Insert result details.');
1229: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
1230: ,p_ext_rslt_id => g_ext_rslt_id
1231: ,p_ext_rcd_id => g_veh_rcd_id
1232: ,p_person_id => g_person_id
1233: ,p_business_group_id => g_bg_id

Line 1556: ben_ext_rslt rslt

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

Line 1570: ben_ext_rslt rslt

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

Line 1580: FROM ben_ext_rslt_dtl

1576: --
1577: --
1578: CURSOR get_ext_asg IS
1579: SELECT person_id, val_01 asg_id, ext_rslt_dtl_id, object_version_number
1580: FROM ben_ext_rslt_dtl
1581: WHERE ext_rslt_id = p_ext_rslt_id
1582: AND ext_rcd_id = l_asg_rcd_id;
1583: --
1584: l_obj_no NUMBER := NULL;

Line 1588: FROM ben_ext_rslt_dtl

1584: l_obj_no NUMBER := NULL;
1585: --
1586: CURSOR get_prim_veh_dtl(p_person_id IN NUMBER) IS
1587: SELECT *
1588: FROM ben_ext_rslt_dtl
1589: WHERE ext_rslt_id = p_ext_rslt_id
1590: AND ext_rcd_id = g_veh_rcd_id
1591: AND person_id = p_person_id;
1592: --

Line 1632: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

1628: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.val_29='||l_prim_veh_dtl.val_29);
1629: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_prim_veh_dtl.val_29 IS NULL THEN
1630: -- Delete this extract rslt details because primary vehicle details
1631: -- do not exist for this assignment as of the start date parameter
1632: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
1633: p_object_version_number => l_prim_veh_dtl.object_version_number);
1634: --
1635: ELSIF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
1636: -- Primary assignment does not qualify for extract

Line 1638: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

1634: --
1635: ELSIF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
1636: -- Primary assignment does not qualify for extract
1637: -- Delete this extract rslt details
1638: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
1639: p_object_version_number => l_prim_veh_dtl.object_version_number);
1640: --
1641: ELSIF l_asg_include = 'Y' THEN
1642: -- Include this Assignment

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

1649: --
1650: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');
1651: l_obj_no := ext_asg_rec.object_version_number;
1652: -- Delete this assignment details record
1653: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
1654: p_object_version_number => l_obj_no);
1655: --
1656: END LOOP;
1657: --

Line 2684: FROM ben_ext_rslt_dtl

2680: l_object_version_no NUMBER;
2681: --
2682: CURSOR chk_exists IS
2683: SELECT ext_rslt_dtl_id
2684: FROM ben_ext_rslt_dtl
2685: WHERE ext_rslt_id = g_ext_rslt_id
2686: AND person_id = g_person_id
2687: AND ext_rcd_id = g_veh_rcd_id
2688: AND val_02 = to_char(p_asg_id)

Line 2746: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id

2742: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');
2743: /* added below variables for bug 6154257 */
2744: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
2745: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
2746: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
2747: ,p_ext_rslt_id => g_ext_rslt_id
2748: ,p_ext_rcd_id => g_veh_rcd_id
2749: ,p_person_id => g_person_id
2750: ,p_business_group_id => g_bg_id

Line 3193: ben_ext_rslt rslt

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

Line 3207: ben_ext_rslt rslt

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

Line 3217: FROM ben_ext_rslt_dtl

3213: --
3214: --
3215: CURSOR get_ext_asg IS
3216: SELECT person_id, val_01 asg_id, ext_rslt_dtl_id, object_version_number
3217: FROM ben_ext_rslt_dtl
3218: WHERE ext_rslt_id = p_ext_rslt_id
3219: AND ext_rcd_id = l_asg_rcd_id;
3220: --
3221: l_obj_no NUMBER := NULL;

Line 3225: FROM ben_ext_rslt_dtl

3221: l_obj_no NUMBER := NULL;
3222: --
3223: CURSOR get_prim_veh_dtl(p_person_id IN NUMBER) IS
3224: SELECT *
3225: FROM ben_ext_rslt_dtl
3226: WHERE ext_rslt_id = p_ext_rslt_id
3227: AND ext_rcd_id = g_veh_rcd_id
3228: AND person_id = p_person_id;
3229: --

Line 3270: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

3266: --
3267: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
3268: -- Primary assignment does not qualify for extract
3269: -- Delete this extract rslt details
3270: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3271: p_object_version_number => l_prim_veh_dtl.object_version_number);
3272: --
3273: ELSIF l_asg_include = 'Y' THEN
3274: -- Include this Assignment

Line 3277: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

3273: ELSIF l_asg_include = 'Y' THEN
3274: -- Include this Assignment
3275: process_prim_veh_04(ext_asg_rec.asg_id);
3276: process_sec_veh_04(ext_asg_rec.asg_id);
3277: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3278: p_object_version_number => l_prim_veh_dtl.object_version_number);
3279: END IF;
3280: --
3281: process_term_primary_asg_04(ext_asg_rec.asg_id);

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

3283: --
3284: hr_utility.trace('POST_PROCESS_RULE_04: Assignment processed, remove it from the extract details table.');
3285: l_obj_no := ext_asg_rec.object_version_number;
3286: -- Delete this assignment details record
3287: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
3288: p_object_version_number => l_obj_no);
3289: --
3290: END LOOP;
3291: --