APPS.PER_IN_ENTRY_VALUE_LEG_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 223: l_element_name pay_element_types_f.element_name %TYPE;

219: IS
220: l_procedure VARCHAR2(100);
221: l_message VARCHAR2(250);
222: l_element_entry_id NUMBER;
223: l_element_name pay_element_types_f.element_name %TYPE;
224: l_ele_name pay_element_types_f.element_name %TYPE;
225: l_check_assg_extra_info NUMBER ;
226:
227: CURSOR c_element_name IS

Line 224: l_ele_name pay_element_types_f.element_name %TYPE;

220: l_procedure VARCHAR2(100);
221: l_message VARCHAR2(250);
222: l_element_entry_id NUMBER;
223: l_element_name pay_element_types_f.element_name %TYPE;
224: l_ele_name pay_element_types_f.element_name %TYPE;
225: l_check_assg_extra_info NUMBER ;
226:
227: CURSOR c_element_name IS
228: SELECT pet.element_information1

Line 229: FROM pay_element_types_f pet

225: l_check_assg_extra_info NUMBER ;
226:
227: CURSOR c_element_name IS
228: SELECT pet.element_information1
229: FROM pay_element_types_f pet
230: WHERE pet.element_type_id = p_element_type_id_o
231: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
232:
233: --

Line 237: FROM pay_element_types_f pet

233: --
234:
235: CURSOR c_other_loan_element(p_element_name VARCHAR2) IS
236: SELECT pee.element_entry_id
237: FROM pay_element_types_f pet
238: ,pay_element_entries_f pee
239: WHERE pet.element_type_id =pee.element_type_id
240: AND pee.assignment_id = p_assignment_id_o
241: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 247: FROM pay_element_types_f pet

243: AND pet.element_information1 = p_element_name;
244:
245: CURSOR c_ele_name IS
246: SELECT pet.element_name
247: FROM pay_element_types_f pet
248: WHERE pet.element_type_id = p_element_type_id_o
249: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
250:
251:

Line 373: l_element_name pay_element_types_f.element_name %TYPE;

369:
370: l_procedure VARCHAR2(100);
371: l_message VARCHAR2(250);
372: l_element_entry_id NUMBER;
373: l_element_name pay_element_types_f.element_name %TYPE;
374: l_ppf_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;
375: l_ppf_amount pay_element_entry_values_f.screen_entry_value%TYPE;
376: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;
377:

Line 380: FROM pay_element_types_f pet

376: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;
377:
378: CURSOR c_element_name IS
379: SELECT pet.ELEMENT_NAME
380: FROM pay_element_types_f pet
381: WHERE pet.element_type_id = p_element_type_id
382: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
383:
384: CURSOR c_ppf_element_entry IS

Line 516: l_element_name pay_element_types_f.element_name %TYPE;

512:
513: l_procedure VARCHAR2(100);
514: l_message VARCHAR2(250);
515: l_element_entry_id NUMBER;
516: l_element_name pay_element_types_f.element_name %TYPE;
517: l_ppf_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;
518: l_ppf_amount pay_element_entry_values_f.screen_entry_value%TYPE;
519: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;
520:

Line 523: FROM pay_element_types_f pet

519: g_ppf_max_exemption_limit_80c ff_globals_f.global_value%TYPE;
520:
521: CURSOR c_element_name IS
522: SELECT pet.ELEMENT_NAME
523: FROM pay_element_types_f pet
524: WHERE pet.element_type_id = p_element_type_id_O
525: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
526:
527: CURSOR c_ppf_element_entry IS