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 1734: -- handle PAY_ELEMENT_ENTRY_VALUES_F history records before PAY_ELEMENT_ENTRIES_F history

1730:
1731:
1732: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1733: -- note that this cursor orders by table name, this is due to the fact that we need to
1734: -- handle PAY_ELEMENT_ENTRY_VALUES_F history records before PAY_ELEMENT_ENTRIES_F history
1735: -- records due to the parent-child relationship of these two tables. Fetch_history routine
1736: -- for elements relies on the parent record in history being intact.
1737: cursor c_history_info (cp_pa_request_id in ghr_pa_requests.pa_request_id%type,
1738: cp_noa_id in ghr_pa_requests.first_noa_id%type) is

Line 1744: 'PAY_ELEMENT_ENTRIES_F', -1,

1740: FROM GHR_PA_HISTORY
1741: WHERE pa_request_id = cp_pa_request_id
1742: AND nature_of_action_id = cp_noa_id
1743: ORDER BY DECODE(table_name, 'PAY_ELEMENT_ENTRY_VALUES_F', -2,
1744: 'PAY_ELEMENT_ENTRIES_F', -1,
1745: pa_history_id) asc;
1746:
1747: --start of bug #5900178
1748: -- Added this below cursor for the bug#5900178 to validate whether per_person_analyses

Line 1838: pay_element_entries_f ele

1834: CURSOR c_element_name1(p_element_entry_id NUMBER) IS
1835: SELECT elt.element_name
1836: FROM PAY_ELEMENT_LINKS_F ell,
1837: PAY_ELEMENT_TYPES_F elt,
1838: pay_element_entries_f ele
1839: WHERE ell.ELEMENT_type_id = elt.element_type_id
1840: AND ele.element_type_id = elt.element_type_id
1841: AND ell.element_link_id = ele.element_link_id
1842: AND ele.element_entry_id = p_element_entry_id;

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

4002: p_del_mode in varchar2 default hr_api.g_delete_next_change,
4003: p_cannot_cancel out nocopy Boolean) is
4004: l_del_warning boolean;
4005: -- this cursor selects the element_entry_id and object_version_number from
4006: -- pay_element_entries_f for the element_entry_id and date_effective passed.
4007: cursor c_elmt ( cp_element_entry_id number,
4008: cp_date_Effective date) is
4009: select element_entry_id,
4010: object_version_number

Line 4011: from pay_element_entries_f

4007: cursor c_elmt ( cp_element_entry_id number,
4008: cp_date_Effective date) is
4009: select element_entry_id,
4010: object_version_number
4011: from pay_element_entries_f
4012: where element_entry_id = cp_element_entry_id and
4013: cp_date_effective between effective_start_date and effective_end_date;
4014: l_c_elmt c_elmt%rowtype;
4015: l_eff_start_date date;

Line 4115: PAY_ELEMENT_ENTRIES_F ELE

4111: IS
4112: SELECT ELT.ELEMENT_NAME
4113: FROM PAY_ELEMENT_TYPES_F ELT,
4114: PAY_ELEMENT_LINKS_F ELL,
4115: PAY_ELEMENT_ENTRIES_F ELE
4116: WHERE TRUNC(cp_eff_date) BETWEEN ELT.EFFECTIVE_START_DATE
4117: AND ELT.EFFECTIVE_END_DATE
4118: AND TRUNC(cp_eff_date) BETWEEN ELL.EFFECTIVE_START_DATE
4119: AND ELL.EFFECTIVE_END_DATE

Line 5936: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee

5932: pet.effective_start_date,
5933: pet.effective_end_date,
5934: pet.processing_type
5935: from
5936: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee
5937: where pee.element_entry_id = cp_element_entry_id and
5938: pee.element_link_id = pel.element_link_id and
5939: pet.element_type_id = pel.element_type_id and
5940: cp_effective_start_date between pee.effective_start_date and pee.effective_end_date and

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

6706: -- IF processed then
6707: -- fetch the other pay value using history id and element entry id.
6708: -- update the pay_element_entry_values_f table with the correct value.
6709: -- ELSE
6710: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6711: -- END If;
6712: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6713: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6714: -- ELSE

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

6709: -- ELSE
6710: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6711: -- END If;
6712: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6713: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6714: -- ELSE
6715: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6716: -- END If;
6717:

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

6711: -- END If;
6712: -- ELSIF element IN ('Retention Allowance', 'Supervisory Differential,'AUO','Availability Pay' Then
6713: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables;
6714: -- ELSE
6715: -- Delete the rows from pay_element_entry_values_f, pay_element_entries_f tables with id and effective start date;
6716: -- END If;
6717:
6718: Procedure delete_other_pay_entries(p_hist_rec in ghr_pa_history%rowtype,
6719: p_element_name IN VARCHAR2 ) IS

Line 6730: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F'

6726:
6727: CURSOR c_history_record IS
6728: SELECT *
6729: FROM ghr_pa_history
6730: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F'
6731: AND information1 = p_hist_rec.information1
6732: AND information2 = p_hist_rec.information2
6733: AND nvl(pa_request_id,0) <> nvl(p_hist_rec.pa_request_id,0);
6734:

Line 6789: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6785: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6786: AND (l_future_othpay_effective_date - 1) ;
6787:
6788: hr_utility.set_location(' After deleting Other pay element entries',30);
6789: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6790: DELETE PAY_ELEMENT_ENTRIES_F
6791: where element_entry_id = p_hist_rec.information1
6792: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6793: AND (l_future_othpay_effective_date - 1) ;

Line 6790: DELETE PAY_ELEMENT_ENTRIES_F

6786: AND (l_future_othpay_effective_date - 1) ;
6787:
6788: hr_utility.set_location(' After deleting Other pay element entries',30);
6789: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6790: DELETE PAY_ELEMENT_ENTRIES_F
6791: where element_entry_id = p_hist_rec.information1
6792: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6793: AND (l_future_othpay_effective_date - 1) ;
6794:

Line 6810: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6806: DELETE pay_element_entry_values_f
6807: where element_entry_id = p_hist_rec.information1;
6808:
6809:
6810: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6811: DELETE PAY_ELEMENT_ENTRIES_F
6812: where element_entry_id = p_hist_rec.information1;
6813:
6814: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the

Line 6811: DELETE PAY_ELEMENT_ENTRIES_F

6807: where element_entry_id = p_hist_rec.information1;
6808:
6809:
6810: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6811: DELETE PAY_ELEMENT_ENTRIES_F
6812: where element_entry_id = p_hist_rec.information1;
6813:
6814: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the
6815: -- current other pay action.

Line 6830: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6826: DELETE pay_element_entry_values_f
6827: where element_entry_id = p_hist_rec.information1;
6828: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6829:
6830: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6831:
6832: DELETE PAY_ELEMENT_ENTRIES_F
6833: where element_entry_id = p_hist_rec.information1;
6834: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6832: DELETE PAY_ELEMENT_ENTRIES_F

6828: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6829:
6830: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6831:
6832: DELETE PAY_ELEMENT_ENTRIES_F
6833: where element_entry_id = p_hist_rec.information1;
6834: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6835:
6836: hr_utility.set_location('Leaving delete_other_pay_entries',170);

Line 6846: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

6842: DELETE pay_element_entry_values_f
6843: where element_entry_id = p_hist_rec.information1
6844: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6845:
6846: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6847:
6848: DELETE PAY_ELEMENT_ENTRIES_F
6849: where element_entry_id = p_hist_rec.information1
6850: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

Line 6848: DELETE PAY_ELEMENT_ENTRIES_F

6844: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6845:
6846: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6847:
6848: DELETE PAY_ELEMENT_ENTRIES_F
6849: where element_entry_id = p_hist_rec.information1
6850: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6851:
6852: hr_utility.set_location('Leaving delete_other_pay_entries',70);

Line 7003: ,pay_element_entries_f ele

6999: p_assignment_id IN number,
7000: p_effective_date IN DATE) IS
7001: SELECT '1'
7002: FROM pay_element_types_f elt
7003: ,pay_element_entries_f ele
7004: WHERE elt.element_type_id = ele.element_type_id
7005: AND elt.element_name= p_element_name
7006: AND ele.assignment_id = p_assignment_id
7007: AND elt.business_group_id is NULL