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.PER_CAGR_APPLY_RESULTS_PKG dependencies on HR_GENERAL

Line 117: AND p_effective_date BETWEEN res.start_date and nvl(res.end_date,hr_general.end_of_time)

113: CURSOR csr_request IS
114: SELECT cagr_request_id
115: FROM per_cagr_entitlement_results res
116: WHERE res.assignment_id = p_assignment_id
117: AND p_effective_date BETWEEN res.start_date and nvl(res.end_date,hr_general.end_of_time)
118: AND exists (select 'x'
119: from per_cagr_requests req
120: where req.cagr_request_id = cagr_request_id
121: and req.OPERATION_MODE = 'SA')

Line 258: l_sql := l_sql ||'AND :2 BETWEEN effective_start_date AND nvl(effective_end_date,hr_general.end_of_time)';

254: hr_utility.set_location('Entering:'||l_proc, 5);
255:
256: if p_dt_flag = 'Y' then
257: l_sql := 'SELECT object_version_number, effective_start_date FROM '||p_table_name||' WHERE '||p_pk||' = :1 ';
258: l_sql := l_sql ||'AND :2 BETWEEN effective_start_date AND nvl(effective_end_date,hr_general.end_of_time)';
259: hr_utility.set_location(l_proc, 10);
260: open l_dyn_csr for l_sql using p_pk_id, p_effective_date;
261: fetch l_dyn_csr into p_ovn, l_start_date;
262: close l_dyn_csr;

Line 287: l_sql := l_sql || 'AND :2 BETWEEN start_date and nvl(end_date,hr_general.end_of_time)';

283: end if;
284: else -- not date tracked
285: hr_utility.set_location(l_proc, 40);
286: l_sql := 'SELECT object_version_number FROM '||p_table_name||' WHERE '||p_pk||' = :1 ';
287: l_sql := l_sql || 'AND :2 BETWEEN start_date and nvl(end_date,hr_general.end_of_time)';
288: open l_dyn_csr for l_sql using p_pk_id, p_effective_date;
289: fetch l_dyn_csr into p_ovn;
290: close l_dyn_csr;
291: hr_utility.set_location(l_proc, 50);

Line 612: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);

608: CURSOR csr_placement_id IS
609: SELECT placement_id
610: FROM per_spinal_point_placements_f
611: WHERE assignment_id = p_params.assignment_id
612: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);
613:
614: TYPE t_api_details IS TABLE OF csr_api%ROWTYPE INDEX BY BINARY_INTEGER;
615:
616: l_api_name per_cagr_apis.api_name%type;

Line 794: AND nvl(el.EFFECTIVE_END_DATE,hr_general.end_of_time)

790: AND ee.ELEMENT_LINK_ID = el.ELEMENT_LINK_ID
791: AND ee.ASSIGNMENT_ID = p_assignment_id
792: AND (p_entry_id is null or (p_entry_id is not null and ee.element_entry_id = p_entry_id))
793: AND p_params.effective_date BETWEEN el.EFFECTIVE_START_DATE
794: AND nvl(el.EFFECTIVE_END_DATE,hr_general.end_of_time)
795: AND p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE
796: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time);
797:
798: Cursor csr_entries_not_exists(p_assignment_id NUMBER

Line 796: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time);

792: AND (p_entry_id is null or (p_entry_id is not null and ee.element_entry_id = p_entry_id))
793: AND p_params.effective_date BETWEEN el.EFFECTIVE_START_DATE
794: AND nvl(el.EFFECTIVE_END_DATE,hr_general.end_of_time)
795: AND p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE
796: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time);
797:
798: Cursor csr_entries_not_exists(p_assignment_id NUMBER
799: ,p_element_type_id NUMBER) IS
800: Select distinct cer.element_type_id

Line 811: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time))

807: Where cer.assignment_id = ee.assignment_id
808: And cer.element_type_id = ee.element_type_id
809: And ee.element_type_id = p_element_type_id
810: And p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE
811: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time))
812: Order by cer.element_type_id;
813:
814:
815: Cursor csr_entitlement_items(p_assignment_id NUMBER,

Line 1250: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))

1246: and not exists (select 'X' from per_cagr_entitlement_results res1
1247: where res1.assignment_id = p_params.assignment_id
1248: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1249: AND res1.chosen_flag = 'Y'
1250: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1251: AND cagr_api_id is not null
1252: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1253: ORDER BY cagr_api_id;
1254:

Line 1252: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)

1248: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1249: AND res1.chosen_flag = 'Y'
1250: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1251: AND cagr_api_id is not null
1252: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1253: ORDER BY cagr_api_id;
1254:
1255: -- get PYS category results to be applied (step_id, increment_number) for an asg.
1256: CURSOR csr_PYS_denorm_results IS

Line 1279: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))

1275: and not exists (select 'X' from per_cagr_entitlement_results res1
1276: where res1.assignment_id = p_params.assignment_id
1277: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1278: AND res1.chosen_flag = 'Y'
1279: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1280: AND cagr_api_id is not null
1281: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1282: ORDER BY cagr_api_id;
1283:

Line 1281: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)

1277: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1278: AND res1.chosen_flag = 'Y'
1279: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1280: AND cagr_api_id is not null
1281: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1282: ORDER BY cagr_api_id;
1283:
1284: -- get PAY category results to be applied (element is set) for an asg.
1285: -- ordered by element_type

Line 1304: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))

1300: and not exists (select 'X' from per_cagr_entitlement_results res1
1301: where res1.assignment_id = p_params.assignment_id
1302: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1303: AND res1.chosen_flag = 'Y'
1304: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1305: AND element_type_id is not null
1306: AND input_value_id is not null
1307: and start_date <= p_params.effective_date -- Bug 12621959
1308: -- AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)

Line 1308: -- AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)

1304: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1305: AND element_type_id is not null
1306: AND input_value_id is not null
1307: and start_date <= p_params.effective_date -- Bug 12621959
1308: -- AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1309: ORDER BY element_type_id, start_date desc; -- Bug 14096456;
1310:
1311:
1312: l_ASG_results t_ASG_results;