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

Line 1751: ,pay_element_types_f pet

1747: ,pay_assignment_actions pac
1748: ,pay_payroll_actions ppa
1749: ,pay_element_entries_f pee
1750: ,pay_run_results prr
1751: ,pay_element_types_f pet
1752: ,pay_balance_types pbt
1753: WHERE paa.assignment_id = c_assignment_id
1754: AND pet.element_information_category = 'AU_EARNINGS'
1755: AND pet.element_information1 = 'Y'

Line 1786: pay_element_types_f pet,

1782: from
1783: pay_element_entries_f pee,
1784: pay_run_results prr,
1785: pay_run_result_values prv,
1786: pay_element_types_f pet,
1787: pay_balance_types pbt
1788: where
1789: pee.element_entry_id=c_element_entry_id
1790: and prr.source_id=pee.element_entry_id

Line 2071: from pay_element_types_f pet

2067: from
2068: ( select distinct nvl(pbt.reporting_name,pbt.balance_name) balance_name
2069: , pdb.defined_balance_id def_id
2070: , pbt.balance_type_id bal_type_id
2071: from pay_element_types_f pet
2072: , per_all_assignments_f paa
2073: , pay_balance_types pbt
2074: , pay_defined_balances pdb
2075: --, pay_balance_dimensions pbd

Line 2262: from pay_element_types_f pet

2258: select prv.result_value
2259: ,ppa.payroll_action_id
2260: ,pac.assignment_action_id
2261: ,ppa.effective_date
2262: from pay_element_types_f pet
2263: ,pay_input_values_f piv
2264: ,per_all_assignments_f paa
2265: ,pay_run_results prr
2266: ,pay_run_result_values prv

Line 2439: from pay_element_types_f pet

2435: select distinct nvl(pbt.reporting_name, pbt.balance_name) balance_name
2436: , pay_balance_pkg.get_value(pdb.defined_balance_id, p_max_assignment_action_id, p_registered_employer,null,null,null,null) balance_value
2437: , pdb.defined_balance_id def_id
2438: , pbt.balance_type_id bal_type_id
2439: from pay_element_types_f pet
2440: , per_all_assignments_f paa
2441: , pay_balance_types pbt
2442: , pay_defined_balances pdb
2443: , pay_payroll_actions ppa

Line 2666: , pay_element_types_f pet

2662: , pet.element_information1
2663: from pay_balance_types pbt
2664: , pay_balance_feeds_f pbf
2665: , pay_input_values_f piv
2666: , pay_element_types_f pet
2667: , pay_element_entries_f pee
2668: , pay_element_links_f pel
2669: , per_all_people_f pap
2670: , per_periods_of_service pps

Line 2684: from pay_element_types_f et

2680: and paa.person_id = pps.person_id
2681: and pbt.balance_name = 'Union Fees'
2682: and pbt.legislation_code = g_legislation_code
2683: and pet.effective_start_date = (select max(et.effective_start_date )
2684: from pay_element_types_f et
2685: where et.element_type_id= pet.element_type_id
2686: and nvl(pps.actual_termination_date,c_year_end)
2687: between pet.effective_Start_date and pet.effective_end_date
2688: );

Line 2705: l_reporting_name pay_element_types_f.reporting_name%type;

2701: AND pbt.balance_type_id = pdb.balance_type_id
2702: AND pbd.balance_dimension_id = pdb.balance_dimension_id
2703: AND pbd.dimension_name = '_ASG_LE_YTD'; --2610141*/
2704:
2705: l_reporting_name pay_element_types_f.reporting_name%type;
2706: l_procedure constant varchar2(80) := g_package || '.archive_union_name';
2707: l_element_information_category pay_element_types_f.element_information_category%type;
2708: l_element_information1 pay_element_types_f.element_information1%type;
2709: l_count number := 0;

Line 2707: l_element_information_category pay_element_types_f.element_information_category%type;

2703: AND pbd.dimension_name = '_ASG_LE_YTD'; --2610141*/
2704:
2705: l_reporting_name pay_element_types_f.reporting_name%type;
2706: l_procedure constant varchar2(80) := g_package || '.archive_union_name';
2707: l_element_information_category pay_element_types_f.element_information_category%type;
2708: l_element_information1 pay_element_types_f.element_information1%type;
2709: l_count number := 0;
2710: l_2006_union_setup_found boolean;
2711: --

Line 2708: l_element_information1 pay_element_types_f.element_information1%type;

2704:
2705: l_reporting_name pay_element_types_f.reporting_name%type;
2706: l_procedure constant varchar2(80) := g_package || '.archive_union_name';
2707: l_element_information_category pay_element_types_f.element_information_category%type;
2708: l_element_information1 pay_element_types_f.element_information1%type;
2709: l_count number := 0;
2710: l_2006_union_setup_found boolean;
2711: --
2712: begin

Line 2892: pay_element_types_f pet,

2888: ,pad.date_from date_from/*Bug 2977533 */
2889: from hr_organization_information hoi,
2890: hr_organization_units hou,
2891: hr_soft_coding_keyflex hsc,
2892: pay_element_types_f pet,
2893: pay_input_values_f piv,
2894: pay_element_links_f pel,
2895: pay_element_entries_f pee,
2896: pay_element_entry_values_f pev,

Line 2957: from pay_element_types_f pet

2953: cursor etp_trans_paid_flags(c_assignment_id per_all_Assignments_f.assignment_id%type,
2954: c_year_start date ,
2955: c_year_end date ) IS
2956: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
2957: from pay_element_types_f pet
2958: ,pay_input_values_f piv
2959: ,per_all_assignments_f paa
2960: ,pay_run_results prr
2961: ,pay_run_result_values prv

Line 3805: pay_element_types_f pet,

3801: c_date_earned pay_payroll_actions.date_earned%TYPE)
3802: is
3803: select pev.screen_entry_value tfn_no
3804: from
3805: pay_element_types_f pet,
3806: pay_input_values_f piv,
3807: pay_element_links_f pel,
3808: pay_element_entries_f pee,
3809: pay_element_entry_values_f pev