APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on HR_API

Line 562: NVL(service_period.final_process_date,hr_api.g_eot),

558: AND (service_period.actual_termination_date
559: IS NULL OR (service_period.actual_termination_date IS NOT NULL
560: AND cp_effective_date <= DECODE(element.post_termination_rule, 'L',
561: service_period.last_standard_process_date, 'F',
562: NVL(service_period.final_process_date,hr_api.g_eot),
563: service_period.actual_termination_date) ))
564: AND element.element_type_id = pete.element_type_id
565: AND pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
566: AND pete.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'

Line 688: NVL(service_period.final_process_date,hr_api.g_eot),

684: IS NULL OR (service_period.actual_termination_date IS NOT NULL
685: AND cp_effective_date <=
686: DECODE(element.post_termination_rule, 'L',
687: service_period.last_standard_process_date, 'F',
688: NVL(service_period.final_process_date,hr_api.g_eot),
689: service_period.actual_termination_date) ))
690: AND element.element_type_id = pete.element_type_id
691: AND pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
692: AND pete.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'

Line 1575: IF l_get_end_date.effective_end_date <> hr_api.g_eot

1571:
1572: END LOOP;
1573: CLOSE c_get_input_value;
1574:
1575: IF l_get_end_date.effective_end_date <> hr_api.g_eot
1576: THEN
1577: hr_utility.set_location(l_proc,150);
1578: IF p_claimed_mileage_o <> p_claimed_mileage OR
1579: p_actual_mileage_o <> p_actual_mileage THEN

Line 1657: IF l_get_end_date.effective_end_date =hr_api.g_eot THEN

1653: LOOP
1654: FETCH c_get_end_date INTO l_get_end_date;
1655: EXIT WHEN c_get_end_date%NOTFOUND;
1656: hr_utility.set_location(l_proc,20);
1657: IF l_get_end_date.effective_end_date =hr_api.g_eot THEN
1658:
1659: OPEN c_get_process_status ( p_assignment_id
1660: ,p_mileage_claim_element
1661: ,p_element_entry_id

Line 2988: l_effective_end_date :=hr_api.g_eot;

2984: l_temp_var NUMBER;
2985: BEGIN
2986: hr_utility.set_location('Insert_company_mileage_claim:' || l_proc,260);
2987: l_effective_start_date :=p_effective_date;
2988: l_effective_end_date :=hr_api.g_eot;
2989:
2990:
2991: BEGIN
2992: l_temp_var := to_number(p_user_rates_table);

Line 3286: l_effective_end_date :=hr_api.g_eot;

3282: l_temp_var NUMBER;
3283: BEGIN
3284: hr_utility.set_location('Enter private element entry process',280);
3285: l_effective_start_date :=p_effective_date;
3286: l_effective_end_date :=hr_api.g_eot;
3287:
3288: BEGIN
3289: l_temp_var := to_number(p_user_rates_table);
3290: