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 1036: FROM pay_element_entries_f

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

Line 1052: FROM pay_element_entries_f pee

1048: CURSOR c_check_element_entry(p_element_type_id NUMBER
1049: ,p_effective_date DATE )
1050: IS
1051: SELECT pee.element_entry_id
1052: FROM pay_element_entries_f pee
1053: WHERE pee.element_type_id = p_element_type_id
1054: AND pee.assignment_id = p_assignment_id
1055: AND TO_CHAR(p_effective_date,'RRRR') = TO_CHAR(pee.effective_start_date,'RRRR') ;
1056:

Line 1060: FROM pay_element_entries_f

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

Line 1104: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;

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

Line 1105: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;

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

Line 1529: FROM pay_element_entries_f

1525:
1526: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
1527: IS
1528: SELECT object_version_number
1529: FROM pay_element_entries_f
1530: WHERE element_entry_id = p_element_entryid;
1531:
1532:
1533:

Line 1537: FROM pay_element_entries_f

1533:
1534: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
1535: IS
1536: SELECT element_type_id
1537: FROM pay_element_entries_f
1538: WHERE element_entry_id = p_element_entryid;
1539:
1540:
1541: --Variables Initialization