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_DTL

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 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 2683: FROM ben_ext_rslt_dtl

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

Line 2738: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id

2734: -- Record does not exist
2735: -- Call API to create extract details record
2736: BEGIN
2737: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');
2738: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
2739: ,p_ext_rslt_id => g_ext_rslt_id
2740: ,p_ext_rcd_id => g_veh_rcd_id
2741: ,p_person_id => g_person_id
2742: ,p_business_group_id => g_bg_id

Line 3108: FROM ben_ext_rslt_dtl

3104: --
3105: --
3106: CURSOR get_ext_asg IS
3107: SELECT person_id, val_01 asg_id, ext_rslt_dtl_id, object_version_number
3108: FROM ben_ext_rslt_dtl
3109: WHERE ext_rslt_id = p_ext_rslt_id
3110: AND ext_rcd_id = l_asg_rcd_id;
3111: --
3112: l_obj_no NUMBER := NULL;

Line 3116: FROM ben_ext_rslt_dtl

3112: l_obj_no NUMBER := NULL;
3113: --
3114: CURSOR get_prim_veh_dtl(p_person_id IN NUMBER) IS
3115: SELECT *
3116: FROM ben_ext_rslt_dtl
3117: WHERE ext_rslt_id = p_ext_rslt_id
3118: AND ext_rcd_id = g_veh_rcd_id
3119: AND person_id = p_person_id;
3120: --

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

3157: --
3158: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
3159: -- Primary assignment does not qualify for extract
3160: -- Delete this extract rslt details
3161: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3162: p_object_version_number => l_prim_veh_dtl.object_version_number);
3163: --
3164: ELSIF l_asg_include = 'Y' THEN
3165: -- Include this Assignment

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

3164: ELSIF l_asg_include = 'Y' THEN
3165: -- Include this Assignment
3166: process_prim_veh_04(ext_asg_rec.asg_id);
3167: process_sec_veh_04(ext_asg_rec.asg_id);
3168: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3169: p_object_version_number => l_prim_veh_dtl.object_version_number);
3170: END IF;
3171: --
3172: process_term_primary_asg_04(ext_asg_rec.asg_id);

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

3174: --
3175: hr_utility.trace('POST_PROCESS_RULE_04: Assignment processed, remove it from the extract details table.');
3176: l_obj_no := ext_asg_rec.object_version_number;
3177: -- Delete this assignment details record
3178: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
3179: p_object_version_number => l_obj_no);
3180: --
3181: END LOOP;
3182: --