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

Line 238: ,pay_element_entries_f pee

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
242: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 374: l_ppf_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;

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:
378: CURSOR c_element_name IS

Line 386: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev

382: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
383:
384: CURSOR c_ppf_element_entry IS
385: SELECT pee.element_entry_id
386: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
387: WHERE pee.assignment_id = p_assignment_id
388: AND pee.element_entry_id =peev.element_entry_id
389: AND pee.element_type_id= p_element_type_id
390: AND peev.screen_entry_value ='Public Provident Fund'

Line 398: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev

394:
395:
396: CURSOR c_ppf_amount(p_ppf_element_entry_id NUMBER ) IS
397: SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT
398: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
399: WHERE pee.assignment_id = p_assignment_id
400: AND pee.element_entry_id =peev.element_entry_id
401: AND pee.element_type_id= p_element_type_id
402: AND pee.element_entry_id= p_ppf_element_entry_id

Line 517: l_ppf_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;

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:
521: CURSOR c_element_name IS

Line 529: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev

525: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
526:
527: CURSOR c_ppf_element_entry IS
528: SELECT pee.element_entry_id
529: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
530: WHERE pee.assignment_id = p_assignment_id_O
531: AND pee.element_entry_id =peev.element_entry_id
532: AND pee.element_type_id= p_element_type_id_O
533: AND peev.screen_entry_value ='Public Provident Fund'

Line 541: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev

537:
538:
539: CURSOR c_ppf_amount(p_ppf_element_entry_id NUMBER ) IS
540: SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT
541: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
542: WHERE pee.assignment_id = p_assignment_id_O
543: AND pee.element_entry_id =peev.element_entry_id
544: AND pee.element_type_id= p_element_type_id_O
545: AND pee.element_entry_id= p_ppf_element_entry_id