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 604: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);

600: CURSOR csr_placement_id IS
601: SELECT placement_id
602: FROM per_spinal_point_placements_f
603: WHERE assignment_id = p_params.assignment_id
604: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);
605:
606: TYPE t_api_details IS TABLE OF csr_api%ROWTYPE INDEX BY BINARY_INTEGER;
607:
608: l_api_name per_cagr_apis.api_name%type;

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

782: AND ee.ELEMENT_LINK_ID = el.ELEMENT_LINK_ID
783: AND ee.ASSIGNMENT_ID = p_assignment_id
784: AND (p_entry_id is null or (p_entry_id is not null and ee.element_entry_id = p_entry_id))
785: AND p_params.effective_date BETWEEN el.EFFECTIVE_START_DATE
786: AND nvl(el.EFFECTIVE_END_DATE,hr_general.end_of_time)
787: AND p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE
788: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time);
789:
790: Cursor csr_entries_not_exists(p_assignment_id NUMBER

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

784: AND (p_entry_id is null or (p_entry_id is not null and ee.element_entry_id = p_entry_id))
785: AND p_params.effective_date BETWEEN el.EFFECTIVE_START_DATE
786: AND nvl(el.EFFECTIVE_END_DATE,hr_general.end_of_time)
787: AND p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE
788: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time);
789:
790: Cursor csr_entries_not_exists(p_assignment_id NUMBER
791: ,p_element_type_id NUMBER) IS
792: Select distinct cer.element_type_id

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

798: Where cer.assignment_id = ee.assignment_id
799: And cer.element_type_id = ee.element_type_id
800: And ee.element_type_id = p_element_type_id
801: And p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE
802: AND nvl(ee.EFFECTIVE_END_DATE,hr_general.end_of_time))
803: Order by cer.element_type_id;
804:
805:
806: Cursor csr_entitlement_items(p_assignment_id NUMBER,

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

1236: and not exists (select 'X' from per_cagr_entitlement_results res1
1237: where res1.assignment_id = p_params.assignment_id
1238: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1239: AND res1.chosen_flag = 'Y'
1240: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1241: AND cagr_api_id is not null
1242: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1243: ORDER BY cagr_api_id;
1244:

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

1238: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1239: AND res1.chosen_flag = 'Y'
1240: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1241: AND cagr_api_id is not null
1242: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1243: ORDER BY cagr_api_id;
1244:
1245: -- get PYS category results to be applied (step_id, increment_number) for an asg.
1246: CURSOR csr_PYS_denorm_results IS

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

1265: and not exists (select 'X' from per_cagr_entitlement_results res1
1266: where res1.assignment_id = p_params.assignment_id
1267: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1268: AND res1.chosen_flag = 'Y'
1269: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1270: AND cagr_api_id is not null
1271: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1272: ORDER BY cagr_api_id;
1273:

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

1267: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1268: AND res1.chosen_flag = 'Y'
1269: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1270: AND cagr_api_id is not null
1271: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1272: ORDER BY cagr_api_id;
1273:
1274: -- get PAY category results to be applied (element is set) for an asg.
1275: -- ordered by element_type

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

1290: and not exists (select 'X' from per_cagr_entitlement_results res1
1291: where res1.assignment_id = p_params.assignment_id
1292: and res1.cagr_entitlement_item_id = cagr_entitlement_item_id
1293: AND res1.chosen_flag = 'Y'
1294: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1295: AND element_type_id is not null
1296: AND input_value_id is not null
1297: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1298: ORDER BY element_type_id;

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

1293: AND res1.chosen_flag = 'Y'
1294: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time))))
1295: AND element_type_id is not null
1296: AND input_value_id is not null
1297: AND p_params.effective_date between start_date and nvl(end_date,hr_general.end_of_time)
1298: ORDER BY element_type_id;
1299:
1300:
1301: l_ASG_results t_ASG_results;