[Home] [Help]
44:
45: BEGIN
46:
47: INSERT INTO fnd_sessions(SESSION_ID , EFFECTIVE_DATE )
48: VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;
49:
50: hr_utility.set_location('p_file_name '||p_file_name,1);
51: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
52:
292: AND l_person_number = action_information8
293: AND l_last_name = action_information10
294: AND l_first_name = action_information11
295: AND l_salary IN (action_information14, action_information13)
296: AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information9;
297:
298: /*
299: ------------ Case 2 Moving with in comapnay -------
300: where org no, cost centre, agreed plan, person no, time for event, salary deatails
310: AND l_cost_centre = action_information6
311: AND l_agreed_product_id = action_information7
312: AND l_person_number = action_information8
313: AND l_salary IN (action_information12, action_information11)
314: AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information9;
315:
316: /*
317: ----------- Case 3 Salary Change --------------
318: where org no, cost centre, person no, time for event, salary details are available
326: AND l_org_number = action_information5
327: AND l_cost_centre = action_information6
328: AND l_person_number = action_information7
329: AND l_salary IN (action_information11, action_information10)
330: AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information8;
331:
332: /*
333: ------------- Case 4 withdrawl ------------
334: where org no, cost centre, person no, time for event details are available
341: AND action_information1 = 'PYSEALEA'
342: AND l_org_number = action_information5
343: AND l_cost_centre = action_information6
344: AND l_person_number = action_information7
345: AND fnd_date.date_to_canonical(to_date(l_time_of_event, 'YYYY/MM/DD')) = action_information8 ;
346: END IF;
347: END IF;
348:
349: p_record_found := l_record_found;