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_CORR_CANC_SF52 dependencies on PAY_ELEMENT_ENTRIES_F

Line 1561: -- handle PAY_ELEMENT_ENTRY_VALUES_F history records before PAY_ELEMENT_ENTRIES_F history

1557:
1558:
1559: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1560: -- note that this cursor orders by table name, this is due to the fact that we need to
1561: -- handle PAY_ELEMENT_ENTRY_VALUES_F history records before PAY_ELEMENT_ENTRIES_F history
1562: -- records due to the parent-child relationship of these two tables. Fetch_history routine
1563: -- for elements relies on the parent record in history being intact.
1564: cursor c_history_info (cp_pa_request_id in ghr_pa_requests.pa_request_id%type,
1565: cp_noa_id in ghr_pa_requests.first_noa_id%type) is

Line 1571: 'PAY_ELEMENT_ENTRIES_F', -1,

1567: FROM GHR_PA_HISTORY
1568: WHERE pa_request_id = cp_pa_request_id
1569: AND nature_of_action_id = cp_noa_id
1570: ORDER BY DECODE(table_name, 'PAY_ELEMENT_ENTRY_VALUES_F', -2,
1571: 'PAY_ELEMENT_ENTRIES_F', -1,
1572: pa_history_id) asc;
1573:
1574: --start of bug #5900178
1575: -- Added this below cursor for the bug#5900178 to validate whether per_person_analyses

Line 1665: pay_element_entries_f ele

1661: CURSOR c_element_name1(p_element_entry_id NUMBER) IS
1662: SELECT elt.element_name
1663: FROM PAY_ELEMENT_LINKS_F ell,
1664: PAY_ELEMENT_TYPES_F elt,
1665: pay_element_entries_f ele
1666: WHERE ell.ELEMENT_type_id = elt.element_type_id
1667: AND ele.element_type_id = elt.element_type_id
1668: AND ell.element_link_id = ele.element_link_id
1669: AND ele.element_entry_id = p_element_entry_id;

Line 3698: -- pay_element_entries_f for the element_entry_id and date_effective passed.

3694: p_del_mode in varchar2 default hr_api.g_delete_next_change,
3695: p_cannot_cancel out nocopy Boolean) is
3696: l_del_warning boolean;
3697: -- this cursor selects the element_entry_id and object_version_number from
3698: -- pay_element_entries_f for the element_entry_id and date_effective passed.
3699: cursor c_elmt ( cp_element_entry_id number,
3700: cp_date_Effective date) is
3701: select element_entry_id,
3702: object_version_number

Line 3703: from pay_element_entries_f

3699: cursor c_elmt ( cp_element_entry_id number,
3700: cp_date_Effective date) is
3701: select element_entry_id,
3702: object_version_number
3703: from pay_element_entries_f
3704: where element_entry_id = cp_element_entry_id and
3705: cp_date_effective between effective_start_date and effective_end_date;
3706: l_c_elmt c_elmt%rowtype;
3707: l_eff_start_date date;

Line 3807: PAY_ELEMENT_ENTRIES_F ELE

3803: IS
3804: SELECT ELT.ELEMENT_NAME
3805: FROM PAY_ELEMENT_TYPES_F ELT,
3806: PAY_ELEMENT_LINKS_F ELL,
3807: PAY_ELEMENT_ENTRIES_F ELE
3808: WHERE TRUNC(cp_eff_date) BETWEEN ELT.EFFECTIVE_START_DATE
3809: AND ELT.EFFECTIVE_END_DATE
3810: AND TRUNC(cp_eff_date) BETWEEN ELL.EFFECTIVE_START_DATE
3811: AND ELL.EFFECTIVE_END_DATE

Line 5585: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee

5581: pet.effective_start_date,
5582: pet.effective_end_date,
5583: pet.processing_type
5584: from
5585: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee
5586: where pee.element_entry_id = cp_element_entry_id and
5587: pee.element_link_id = pel.element_link_id and
5588: pet.element_type_id = pel.element_type_id and
5589: cp_effective_start_date between pee.effective_start_date and pee.effective_end_date and

Line 6355: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;

6351: -- IF processed then
6352: -- fetch the other pay value using history id and element entry id.
6353: -- update the pay_element_entry_values_f table with the correct value.
6354: -- ELSE
6355: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6356: -- END If;
6357: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6359: -- ELSE

Line 6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;

6354: -- ELSE
6355: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6356: -- END If;
6357: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6359: -- ELSE
6360: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6361: -- END If;
6362:

Line 6360: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;

6356: -- END If;
6357: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6358: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6359: -- ELSE
6360: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6361: -- END If;
6362:
6363: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,
6364: p_element_name IN VARCHAR2 ) IS

Line 6375: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F'

6371:
6372: CURSOR c_history_record IS
6373: SELECT *
6374: FROM ghr_pa_history
6375: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F'
6376: AND information1 = p_hist_rec.information1
6377: AND information2 = p_hist_rec.information2
6378: AND nvl(pa_request_id,0) <> nvl(p_hist_rec.pa_request_id,0);
6379:

Line 6434: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6430: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6431: AND (l_future_othpay_effective_date - 1) ;
6432:
6433: hr_utility.set_location(' After deleting Other pay element entries',30);
6434: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6435: DELETE PAY_ELEMENT_ENTRIES_F
6436: where element_entry_id = p_hist_rec.information1
6437: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6438: AND (l_future_othpay_effective_date - 1) ;

Line 6435: DELETE PAY_ELEMENT_ENTRIES_F

6431: AND (l_future_othpay_effective_date - 1) ;
6432:
6433: hr_utility.set_location(' After deleting Other pay element entries',30);
6434: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6435: DELETE PAY_ELEMENT_ENTRIES_F
6436: where element_entry_id = p_hist_rec.information1
6437: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6438: AND (l_future_othpay_effective_date - 1) ;
6439:

Line 6455: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6451: DELETE pay_element_entry_values_f
6452: where element_entry_id = p_hist_rec.information1;
6453:
6454:
6455: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6456: DELETE PAY_ELEMENT_ENTRIES_F
6457: where element_entry_id = p_hist_rec.information1;
6458:
6459: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the

Line 6456: DELETE PAY_ELEMENT_ENTRIES_F

6452: where element_entry_id = p_hist_rec.information1;
6453:
6454:
6455: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6456: DELETE PAY_ELEMENT_ENTRIES_F
6457: where element_entry_id = p_hist_rec.information1;
6458:
6459: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the
6460: -- current other pay action.

Line 6475: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6471: DELETE pay_element_entry_values_f
6472: where element_entry_id = p_hist_rec.information1;
6473: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6474:
6475: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6476:
6477: DELETE PAY_ELEMENT_ENTRIES_F
6478: where element_entry_id = p_hist_rec.information1;
6479: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6477: DELETE PAY_ELEMENT_ENTRIES_F

6473: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6474:
6475: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6476:
6477: DELETE PAY_ELEMENT_ENTRIES_F
6478: where element_entry_id = p_hist_rec.information1;
6479: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6480:
6481: hr_utility.set_location('Leaving delete_other_pay_entries',170);

Line 6491: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6487: DELETE pay_element_entry_values_f
6488: where element_entry_id = p_hist_rec.information1
6489: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6490:
6491: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6492:
6493: DELETE PAY_ELEMENT_ENTRIES_F
6494: where element_entry_id = p_hist_rec.information1
6495: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6493: DELETE PAY_ELEMENT_ENTRIES_F

6489: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6490:
6491: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6492:
6493: DELETE PAY_ELEMENT_ENTRIES_F
6494: where element_entry_id = p_hist_rec.information1
6495: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6496:
6497: hr_utility.set_location('Leaving delete_other_pay_entries',70);

Line 6648: ,pay_element_entries_f ele

6644: p_assignment_id IN number,
6645: p_effective_date IN DATE) IS
6646: SELECT '1'
6647: FROM pay_element_types_f elt
6648: ,pay_element_entries_f ele
6649: WHERE elt.element_type_id = ele.element_type_id
6650: AND elt.element_name= p_element_name
6651: AND ele.assignment_id = p_assignment_id
6652: AND elt.business_group_id is NULL