APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ELEMENT_ENTRIES_F

Line 107: FROM pay_element_entries_f

103: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
104: IS
105: SELECT object_version_number
106: ,effective_start_date
107: FROM pay_element_entries_f
108: WHERE element_entry_id = p_element_entryid;
109:
110: CURSOR c_get_screen_value (p_element_entryid NUMBER
111: ,p_input NUMBER )

Line 123: FROM pay_element_entries_f pee

119: CURSOR c_check_element_entry(p_element_type_id NUMBER
120: ,p_effective_date DATE )
121: IS
122: SELECT pee.element_entry_id
123: FROM pay_element_entries_f pee
124: WHERE pee.element_type_id = p_element_type_id
125: AND pee.assignment_id = p_assignment_id
126: AND TO_CHAR(p_effective_date,'RRRR') = TO_CHAR(pee.effective_start_date,'RRRR') ;
127:

Line 131: FROM pay_element_entries_f

127:
128: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
129: IS
130: SELECT element_type_id
131: FROM pay_element_entries_f
132: WHERE element_entry_id = p_element_entryid;
133:
134: CURSOR c_get_prev_amts
135: IS

Line 183: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;

179: l_start_date DATE ;
180: l_end_date DATE ;
181: l_effective_start_date DATE ;
182: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
183: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
184: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
185: l_submitted NUMBER ;
186: l_prev_submitted NUMBER ;
187: l_check NUMBER :=0;

Line 184: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;

180: l_end_date DATE ;
181: l_effective_start_date DATE ;
182: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
183: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
184: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
185: l_submitted NUMBER ;
186: l_prev_submitted NUMBER ;
187: l_check NUMBER :=0;
188: l_exempted_amount NUMBER ;

Line 1104: pay_element_entries_f pev,

1100: CURSOR c_get_value
1101: IS
1102: SELECT screen_entry_value
1103: FROM pay_element_entry_values_f peev,
1104: pay_element_entries_f pev,
1105: pay_element_types_f pet,
1106: pay_input_values_f piv
1107: WHERE pev.assignment_id = p_assignment_id
1108: AND pev.element_type_id = pet.element_type_id

Line 1246: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1242: l_bill_amt NUMBER ;
1243: l_ovn NUMBER;
1244: l_extra_id_out NUMBER;
1245: l_ovn_out NUMBER;
1246: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1247:
1248: l_person_profile_id NUMBER;
1249: l_bg_profile_id NUMBER;
1250:

Line 1812: FROM pay_element_entries_f

1808:
1809: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
1810: IS
1811: SELECT object_version_number
1812: FROM pay_element_entries_f
1813: WHERE element_entry_id = p_element_entryid;
1814:
1815:
1816:

Line 1820: FROM pay_element_entries_f

1816:
1817: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
1818: IS
1819: SELECT element_type_id
1820: FROM pay_element_entries_f
1821: WHERE element_entry_id = p_element_entryid;
1822:
1823:
1824: --Variables Initialization