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_TAX_UTILS dependencies on PAY_ELEMENT_TYPES_F

Line 341: from pay_element_types_f pet

337:
338: cursor c_ele_id
339: is
340: select pee.element_entry_id,pee.effective_end_date
341: from pay_element_types_f pet
342: ,pay_input_values_f piv
343: ,pay_element_entries_f pee
344: ,pay_element_entry_values_f pev
345: ,pay_assignment_actions pac

Line 361: from pay_element_types_f pet

357:
358: cursor c_ele_id_latest
359: is
360: select pee.element_entry_id,pee.effective_end_date
361: from pay_element_types_f pet
362: ,pay_input_values_f piv
363: ,pay_element_entries_f pee
364: ,pay_element_entry_values_f pev
365: ,pay_assignment_actions pac

Line 514: from pay_element_types_f pet

510: is
511:
512: cursor get_house_rent_entry_id(l_prev_effective_date in date) is
513: select pee.element_entry_id
514: from pay_element_types_f pet
515: ,pay_input_values_f piv
516: ,pay_element_entries_f pee
517: ,pay_element_entry_values_f pev
518: ,pay_assignment_actions pac

Line 1820: From pay_element_types_f

1816: Select element_information1,
1817: element_information2,
1818: element_information3,
1819: element_information4
1820: From pay_element_types_f
1821: Where element_type_id = p_element_type_id
1822: and p_date_earned between effective_start_date and effective_end_date;
1823:
1824: l_procedure VARCHAR2(250);

Line 2110: pay_element_types_f pet

2106: l_payroll_id IN NUMBER)
2107: IS
2108: SELECT pel.element_link_id
2109: FROM pay_element_links_f pel,
2110: pay_element_types_f pet
2111: WHERE pet.element_name = p_element_name
2112: AND pet.element_type_id = pel.element_type_id
2113: AND (pel.payroll_id = l_payroll_id
2114: OR (pel.payroll_id IS NULL

Line 2334: FROM pay_element_types_f

2330: RETURN NUMBER IS
2331: CURSOR c_get_perk_details IS
2332: SELECT element_information1
2333: ,NVL(element_information6,'Y')
2334: FROM pay_element_types_f
2335: WHERE element_type_id = p_element_type_id
2336: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
2337:
2338: CURSOR c_exemption (p_perk_name IN VARCHAR2) IS

Line 2343: l_perk_name pay_element_types_f.element_information1%TYPE;

2339: SELECT fnd_number.canonical_to_number(exemption_amount)
2340: FROM pay_in_other_perquisites_v
2341: WHERE perquisite_name = p_perk_name;
2342:
2343: l_perk_name pay_element_types_f.element_information1%TYPE;
2344: l_procedure VARCHAR2(100);
2345: l_message VARCHAR2(255);
2346:
2347: BEGIN

Line 2422: l_element_name pay_element_types_f.element_name %TYPE;

2418: l_eff_date_tbl t_eff_date;
2419: l_hra number;
2420: l_curr_period_num number;
2421: l_80gg_flag VARCHAR2(3);
2422: l_element_name pay_element_types_f.element_name %TYPE;
2423: l_input_name pay_input_values_f.name%TYPE;
2424:
2425: CURSOR c_claim_80gg_flag(c_assignment_action_id NUMBER
2426: ,c_element_name IN VARCHAR2

Line 2432: pay_element_types_f pet

2428: SELECT prv.result_value
2429: FROM pay_run_result_values prv,
2430: pay_run_results prr,
2431: pay_input_values_f piv,
2432: pay_element_types_f pet
2433: WHERE prv.run_result_id = prr.run_result_id
2434: AND prr.assignment_action_id = c_assignment_action_id
2435: AND prr.element_type_id = pet.element_type_id
2436: AND pet.element_name = c_element_name

Line 2452: pay_element_types_f pet

2448: select pev.screen_entry_value
2449: from pay_element_entries_f pee,
2450: pay_element_entry_values_f pev,
2451: pay_input_values_f piv,
2452: pay_element_types_f pet
2453: ,pay_assignment_actions paa
2454: where pev.element_entry_id = pee.element_entry_id
2455: and pee.element_type_id = piv.element_type_id
2456: and pev.input_value_id = piv.input_value_id

Line 2644: pay_element_types_f et,

2640: FROM pay_assignment_actions aa,
2641: pay_payroll_actions pa,
2642: pay_element_entries_f ee,
2643: pay_element_links_f el,
2644: pay_element_types_f et,
2645: pay_element_entry_values_f peev
2646: WHERE aa.payroll_action_id = pa.payroll_action_id
2647: AND aa.assignment_id = ee.assignment_id
2648: and ee.element_entry_id = peev.element_entry_id

Line 4627: pay_element_types_f pet

4623: AND cur_pay.effective_date between ptp.start_date and ptp.end_date
4624: AND ptp.payroll_id = cur_pay.payroll_id
4625: AND EXISTS (SELECT ''
4626: FROM pay_run_results prr,
4627: pay_element_types_f pet
4628: WHERE prr.assignment_action_id = prev_asg.assignment_action_id
4629: AND prr.element_type_id = pet.element_type_id
4630: AND pet.legislation_code ='IN'
4631: AND pet.element_name ='Form16 Income Tax Information')

Line 4730: pay_element_types_f pet

4726: AND prt.run_type_id = ASSACT.run_type_id
4727: AND prt.run_type_name ='Regular Run'
4728: AND EXISTS ( SELECT '1' FROM
4729: pay_run_results prr,
4730: pay_element_types_f pet
4731: WHERE prr.assignment_action_id = ASSACT.assignment_action_id
4732: AND prr.element_type_id = pet.element_type_id
4733: AND pet.legislation_code ='IN'
4734: AND pet.element_name ='Form16 Income Information');