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.PAY_IN_MED_WEB_ADI dependencies on PAY_ELEMENT_ENTRIES_F

Line 135: FROM pay_element_entries_f

131: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
132: IS
133: SELECT object_version_number
134: ,effective_start_date
135: FROM pay_element_entries_f
136: WHERE element_entry_id = p_element_entryid;
137:
138: CURSOR c_get_screen_value (p_element_entryid NUMBER
139: ,p_input NUMBER )

Line 151: FROM pay_element_entries_f pee

147: CURSOR c_check_element_entry(p_element_type_id NUMBER
148: ,p_effective_date DATE )
149: IS
150: SELECT pee.element_entry_id
151: FROM pay_element_entries_f pee
152: WHERE pee.element_type_id = p_element_type_id
153: AND pee.assignment_id = p_assignment_id
154: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date;
155:

Line 159: FROM pay_element_entries_f

155:
156: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
157: IS
158: SELECT element_type_id
159: FROM pay_element_entries_f
160: WHERE element_entry_id = p_element_entryid;
161:
162: CURSOR c_get_prev_amts
163: IS

Line 208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;

204: l_effective_start_date DATE ;
205: l_ben_start_date DATE ;
206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
211: l_entry_information7 pay_element_entries_f.entry_information2%TYPE ;
212: l_check NUMBER :=0;

Line 209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;

205: l_ben_start_date DATE ;
206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
211: l_entry_information7 pay_element_entries_f.entry_information2%TYPE ;
212: l_check NUMBER :=0;
213: l_approved_bill_amount NUMBER ;

Line 210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;

206: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
211: l_entry_information7 pay_element_entries_f.entry_information2%TYPE ;
212: l_check NUMBER :=0;
213: l_approved_bill_amount NUMBER ;
214: l_prev_bill_amount NUMBER ;

Line 211: l_entry_information7 pay_element_entries_f.entry_information2%TYPE ;

207: l_ben_version_no per_assignment_extra_info.object_version_number%TYPE ;
208: l_entry_information1 pay_element_entries_f.entry_information2%TYPE ;
209: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
210: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
211: l_entry_information7 pay_element_entries_f.entry_information2%TYPE ;
212: l_check NUMBER :=0;
213: l_approved_bill_amount NUMBER ;
214: l_prev_bill_amount NUMBER ;
215:

Line 804: FROM pay_element_entries_f

800:
801: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
802: IS
803: SELECT object_version_number
804: FROM pay_element_entries_f
805: WHERE element_entry_id = p_element_entryid;
806:
807:
808: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)

Line 811: FROM pay_element_entries_f

807:
808: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
809: IS
810: SELECT element_type_id
811: FROM pay_element_entries_f
812: WHERE element_entry_id = p_element_entryid;
813:
814:
815: --Variables Initialization

Line 1037: FROM pay_element_entries_f

1033: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
1034: IS
1035: SELECT object_version_number
1036: ,effective_start_date
1037: FROM pay_element_entries_f
1038: WHERE element_entry_id = p_element_entryid;
1039:
1040: CURSOR c_get_screen_value (p_element_entryid NUMBER
1041: ,p_input NUMBER )

Line 1053: FROM pay_element_entries_f pee

1049: CURSOR c_check_element_entry(p_element_type_id NUMBER
1050: ,p_effective_date DATE )
1051: IS
1052: SELECT pee.element_entry_id
1053: FROM pay_element_entries_f pee
1054: WHERE pee.element_type_id = p_element_type_id
1055: AND pee.assignment_id = p_assignment_id
1056: AND TO_CHAR(p_effective_date,'RRRRMM') = TO_CHAR(pee.effective_start_date,'RRRRMM') ; /*Added MM check for Bug 12819651 */
1057:

Line 1061: FROM pay_element_entries_f

1057:
1058: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
1059: IS
1060: SELECT element_type_id
1061: FROM pay_element_entries_f
1062: WHERE element_entry_id = p_element_entryid;
1063:
1064: CURSOR c_get_prev_amts
1065: IS

Line 1105: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;

1101: l_start_date DATE ;
1102: l_end_date DATE ;
1103: l_effective_start_date DATE ;
1104: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
1105: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
1106: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
1107: l_submitted NUMBER ;
1108: l_prev_submitted NUMBER ;
1109: l_check NUMBER :=0;

Line 1106: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;

1102: l_end_date DATE ;
1103: l_effective_start_date DATE ;
1104: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
1105: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
1106: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
1107: l_submitted NUMBER ;
1108: l_prev_submitted NUMBER ;
1109: l_check NUMBER :=0;
1110: l_exempted_amount NUMBER ;

Line 1541: FROM pay_element_entries_f

1537:
1538: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
1539: IS
1540: SELECT object_version_number
1541: FROM pay_element_entries_f
1542: WHERE element_entry_id = p_element_entryid;
1543:
1544:
1545:

Line 1549: FROM pay_element_entries_f

1545:
1546: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
1547: IS
1548: SELECT element_type_id
1549: FROM pay_element_entries_f
1550: WHERE element_entry_id = p_element_entryid;
1551:
1552:
1553: --Variables Initialization