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 1587: IF l_get_end_date.effective_end_date <> hr_api.g_eot

1583:
1584: END LOOP;
1585: CLOSE c_get_input_value;
1586:
1587: IF l_get_end_date.effective_end_date <> hr_api.g_eot
1588: THEN
1589: hr_utility.set_location(l_proc,150);
1590: IF p_claimed_mileage_o <> p_claimed_mileage OR
1591: p_actual_mileage_o <> p_actual_mileage THEN

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

1665: LOOP
1666: FETCH c_get_end_date INTO l_get_end_date;
1667: EXIT WHEN c_get_end_date%NOTFOUND;
1668: hr_utility.set_location(l_proc,20);
1669: IF l_get_end_date.effective_end_date =hr_api.g_eot THEN
1670:
1671: OPEN c_get_process_status ( p_assignment_id
1672: ,p_mileage_claim_element
1673: ,p_element_entry_id

Line 3003: l_effective_end_date :=hr_api.g_eot;

2999: l_temp_var NUMBER;
3000: BEGIN
3001: hr_utility.set_location('Insert_company_mileage_claim:' || l_proc,260);
3002: l_effective_start_date :=p_effective_date;
3003: l_effective_end_date :=hr_api.g_eot;
3004:
3005:
3006: BEGIN
3007: l_temp_var := to_number(p_user_rates_table);

Line 3306: l_effective_end_date :=hr_api.g_eot;

3302: l_temp_var NUMBER;
3303: BEGIN
3304: hr_utility.set_location('Enter private element entry process',280);
3305: l_effective_start_date :=p_effective_date;
3306: l_effective_end_date :=hr_api.g_eot;
3307:
3308: BEGIN
3309: l_temp_var := to_number(p_user_rates_table);
3310: