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.GHR_ELT_TO_BEN_PKG dependencies on FND_DATE

Line 2120: --and fnd_date.canonical_to_date(ppei.pei_information14) >= l_agency_effective_date

2116: and paf.primary_flag='Y'
2117: and paf.assignment_type<>'B'
2118: and ppf.current_employee_flag='Y'
2119: and ppf.effective_end_date > l_agency_effective_date
2120: --and fnd_date.canonical_to_date(ppei.pei_information14) >= l_agency_effective_date
2121: and ppei.pei_information14 IS NOT NULL
2122: and ppf.business_group_id=paf.business_group_id
2123: and ppf.business_group_id= NVL(p_business_group_id,ppf.business_group_id)
2124: AND ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like SUBSTR(p_agency_code,1,2)||SUBSTR(p_agency_sub_code,1,2)||'%' ;

Line 2248: l_agency_effective_date := fnd_date.canonical_to_date(p_agency_effective_date);

2244:
2245: BEGIN
2246: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');
2247: l_program_name := 'GHR_TSP_CONV_'||l_req;
2248: l_agency_effective_date := fnd_date.canonical_to_date(p_agency_effective_date);
2249: BEGIN --B1
2250: l_tsp_abv_agcy_rec_cnt:=0;
2251: for l_tsp_agncy_date in c_tsp_agncy_date LOOP
2252: l_process_log_upd_flag:=0;

Line 2264: IF fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >= l_agency_effective_date THEN

2260: -- l_employee_number := l_tsp_agncy_date.national_identifier;
2261: l_employee_number := l_tsp_agncy_date.employee_number;
2262: l_employee_name := l_tsp_agncy_date.full_name;
2263:
2264: IF fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >= l_agency_effective_date THEN
2265: IF l_agency_effective_date < l_effective_start_date THEN
2266: l_calculated_date := l_effective_start_date;
2267: ELSE
2268: l_calculated_date:= l_agency_effective_date;

Line 2344: IF (fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >= l_agency_effective_date

2340: ,p_update_warning => l_out_update_warning
2341: );
2342:
2343: l_tsp_abv_agcy_rec_cnt := l_tsp_abv_agcy_rec_cnt + 1;
2344: IF (fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >= l_agency_effective_date
2345: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE) THEN
2346: FOR l_get_tsp_date IN c_get_tsp_date LOOP
2347: l_tsp_start_date := l_get_tsp_date.screen_entry_value;
2348: EXIT;

Line 2345: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE) THEN

2341: );
2342:
2343: l_tsp_abv_agcy_rec_cnt := l_tsp_abv_agcy_rec_cnt + 1;
2344: IF (fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >= l_agency_effective_date
2345: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE) THEN
2346: FOR l_get_tsp_date IN c_get_tsp_date LOOP
2347: l_tsp_start_date := l_get_tsp_date.screen_entry_value;
2348: EXIT;
2349: END LOOP;

Line 2413: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_agency_effective_date THEN

2409: open c_peopleei_getovn( l_peopleei_data.person_extra_info_id );
2410: Fetch c_peopleei_getovn into l_peopleei_data.object_version_number;
2411: close c_peopleei_getovn;
2412:
2413: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_agency_effective_date THEN
2414: IF l_agency_effective_date < l_effective_start_date THEN
2415: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_effective_start_date THEN
2416: l_peopleei_data.pei_information14 := fnd_date.date_to_canonical(l_effective_start_date);
2417: l_cotrib_update_flag:=1;

Line 2415: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_effective_start_date THEN

2411: close c_peopleei_getovn;
2412:
2413: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_agency_effective_date THEN
2414: IF l_agency_effective_date < l_effective_start_date THEN
2415: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_effective_start_date THEN
2416: l_peopleei_data.pei_information14 := fnd_date.date_to_canonical(l_effective_start_date);
2417: l_cotrib_update_flag:=1;
2418: ELSE
2419: l_cotrib_update_flag:=0;

Line 2416: l_peopleei_data.pei_information14 := fnd_date.date_to_canonical(l_effective_start_date);

2412:
2413: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_agency_effective_date THEN
2414: IF l_agency_effective_date < l_effective_start_date THEN
2415: IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14) > l_effective_start_date THEN
2416: l_peopleei_data.pei_information14 := fnd_date.date_to_canonical(l_effective_start_date);
2417: l_cotrib_update_flag:=1;
2418: ELSE
2419: l_cotrib_update_flag:=0;
2420: END IF;

Line 2422: l_peopleei_data.pei_information14 := fnd_date.date_to_canonical(l_agency_effective_date);

2418: ELSE
2419: l_cotrib_update_flag:=0;
2420: END IF;
2421: ELSE
2422: l_peopleei_data.pei_information14 := fnd_date.date_to_canonical(l_agency_effective_date);
2423: l_cotrib_update_flag:=1;
2424: END IF;
2425: IF l_cotrib_update_flag = 1 THEN
2426: l_cotrib_update_flag:=0;

Line 2495: IF (l_agency_effective_date <= fnd_date.canonical_to_date(l_agncy_contrib_elig_date)

2491: ghr_history_api.post_update_process;
2492: ghr_history_api.reinit_g_session_var;
2493: ghr_api.g_api_dml := FALSE;
2494:
2495: IF (l_agency_effective_date <= fnd_date.canonical_to_date(l_agncy_contrib_elig_date)
2496: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE)
2497: AND l_process_log_upd_flag = 0 THEN
2498: l_tsp_abv_agcy_rec_cnt := l_tsp_abv_agcy_rec_cnt+1;
2499: FOR l_get_tsp_date IN c_get_tsp_date LOOP

Line 2496: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE)

2492: ghr_history_api.reinit_g_session_var;
2493: ghr_api.g_api_dml := FALSE;
2494:
2495: IF (l_agency_effective_date <= fnd_date.canonical_to_date(l_agncy_contrib_elig_date)
2496: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE)
2497: AND l_process_log_upd_flag = 0 THEN
2498: l_tsp_abv_agcy_rec_cnt := l_tsp_abv_agcy_rec_cnt+1;
2499: FOR l_get_tsp_date IN c_get_tsp_date LOOP
2500: l_tsp_start_date := l_get_tsp_date.screen_entry_value;

Line 2521: END IF;--IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14)

2517: ELSE
2518: l_process_log_upd_flag:=0;
2519: END IF;
2520: END IF;--IF l_cotrib_update_flag = 1
2521: END IF;--IF fnd_date.canonical_to_date(l_peopleei_data.pei_information14)
2522: Exception
2523: When Others then
2524: --Bug # 9329643 Modified SSN to Emp No
2525: ghr_wgi_pkg.create_ghr_errorlog(

Line 2540: END IF;--IF fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >

2536: ghr_api.g_api_dml := FALSE;
2537:
2538: END;--B4
2539: END IF;--l_retirement_plan IN('K','L', 'M
2540: END IF;--IF fnd_date.canonical_to_date(l_agncy_contrib_elig_date) >
2541: END LOOP;--for l_tsp_agncy_date
2542: BEGIN --B4
2543: if l_tsp_abv_agcy_rec_cnt <> 0 then
2544:

Line 2585: (fnd_date.canonical_to_date(l_rpa_agncy_contrib_elig_date) <> l_rpa_effective_date) THEN

2581: l_update_flag := 1;
2582: l_rpa_tsp_status_code := 'T';
2583: END IF;
2584: IF l_rpa_agncy_contrib_elig_date IS NOT NULL AND
2585: (fnd_date.canonical_to_date(l_rpa_agncy_contrib_elig_date) <> l_rpa_effective_date) THEN
2586: l_elig_date_flag :=1;
2587: END IF;
2588: IF l_update_flag = 1 OR l_elig_date_flag =1 THEN
2589: l_tsp_future_rec_cnt := l_tsp_future_rec_cnt+1;

Line 2600: SET rei_information17 = fnd_date.date_to_canonical(l_rpa_effective_date)

2596: END IF;
2597: IF l_elig_date_flag = 1 THEN
2598: l_elig_date_flag:=0;
2599: UPDATE ghr_pa_request_extra_info
2600: SET rei_information17 = fnd_date.date_to_canonical(l_rpa_effective_date)
2601: where information_type='GHR_US_PAR_BENEFITS'
2602: AND pa_request_id = l_pa_request_id;
2603: END IF;
2604: END IF;