APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ELEMENT_ENTRIES_F

Line 112: FROM pay_element_entries_f pee

108: )
109: IS
110: SELECT object_version_number
111: ,effective_start_date
112: FROM pay_element_entries_f pee
113: WHERE element_entry_id = p_element_entryid;
114: -- AND TO_CHAR(p_effective_date,'RRRRMM') = TO_CHAR(pee.effective_start_date,'RRRRMM') ;
115:
116: CURSOR c_get_screen_value (p_element_entryid NUMBER

Line 129: FROM pay_element_entries_f pee

125: CURSOR c_check_element_entry(p_element_type_id NUMBER
126: ,p_effective_date DATE )
127: IS
128: SELECT pee.element_entry_id
129: FROM pay_element_entries_f pee
130: WHERE pee.element_type_id = p_element_type_id
131: AND pee.assignment_id = p_assignment_id
132: AND TO_CHAR(p_effective_date,'RRRRMM') = TO_CHAR(pee.effective_start_date,'RRRRMM') ;
133:

Line 137: FROM pay_element_entries_f

133:
134: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
135: IS
136: SELECT element_type_id
137: FROM pay_element_entries_f
138: WHERE element_entry_id = p_element_entryid;
139:
140: CURSOR c_get_prev_amts
141: IS

Line 189: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;

185: l_start_date DATE ;
186: l_end_date DATE ;
187: l_effective_start_date DATE ;
188: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
189: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
190: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
191: l_submitted NUMBER ;
192: l_prev_submitted NUMBER ;
193: l_check NUMBER :=0;

Line 190: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;

186: l_end_date DATE ;
187: l_effective_start_date DATE ;
188: l_object_version_no per_assignment_extra_info.object_version_number%TYPE ;
189: l_entry_information5 pay_element_entries_f.entry_information2%TYPE ;
190: l_entry_information3 pay_element_entries_f.entry_information2%TYPE ;
191: l_submitted NUMBER ;
192: l_prev_submitted NUMBER ;
193: l_check NUMBER :=0;
194: l_exempted_amount NUMBER ;

Line 1153: pay_element_entries_f pev,

1149: CURSOR c_get_value
1150: IS
1151: SELECT screen_entry_value
1152: FROM pay_element_entry_values_f peev,
1153: pay_element_entries_f pev,
1154: pay_element_types_f pet,
1155: pay_input_values_f piv
1156: WHERE pev.assignment_id = p_assignment_id
1157: AND pev.element_type_id = pet.element_type_id

Line 1295: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1291: l_bill_amt NUMBER ;
1292: l_ovn NUMBER;
1293: l_extra_id_out NUMBER;
1294: l_ovn_out NUMBER;
1295: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1296:
1297: l_person_profile_id NUMBER;
1298: l_bg_profile_id NUMBER;
1299:

Line 1885: FROM pay_element_entries_f

1881:
1882: CURSOR c_get_ele_object_version(p_element_entryid NUMBER )
1883: IS
1884: SELECT object_version_number
1885: FROM pay_element_entries_f
1886: WHERE element_entry_id = p_element_entryid;
1887:
1888:
1889:

Line 1893: FROM pay_element_entries_f

1889:
1890: CURSOR c_get_ele_type_id(p_element_entryid NUMBER)
1891: IS
1892: SELECT element_type_id
1893: FROM pay_element_entries_f
1894: WHERE element_entry_id = p_element_entryid;
1895:
1896:
1897: --Variables Initialization