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 743: from pay_element_types_f pet

739: AND pbd.dimension_name = '_ASG_LE_YTD';
740:
741: cursor c_get_fw_union_bal_type_id is
742: select distinct pbt.balance_type_id
743: from pay_element_types_f pet
744: , pay_balance_types pbt
745: , pay_input_values_f piv
746: , pay_balance_feeds_f pbf
747: where pet.element_information_category = 'AU_VOLUNTARY DEDUCTIONS'

Line 2722: ,pay_element_types_f pet

2718: ,pay_assignment_actions pac
2719: ,pay_payroll_actions ppa
2720: ,pay_element_entries_f pee
2721: ,pay_run_results prr
2722: ,pay_element_types_f pet
2723: /* below added for bug 7571001 */
2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
2725: , PAY_BALANCE_ATTRIBUTES pba
2726: ,pay_defined_balances pdb

Line 2774: pay_element_types_f pet,

2770: from
2771: pay_element_entries_f pee,
2772: pay_run_results prr,
2773: pay_run_result_values prv,
2774: pay_element_types_f pet,
2775: pay_balance_types pbt
2776: /* below added for bug 7571001 */
2777: ,PAY_BALANCE_FEEDS_F pbf
2778: ,pay_input_values_f piv

Line 3309: , pay_element_types_f pet

3305: , pet.element_information1
3306: from pay_balance_types pbt
3307: , pay_balance_feeds_f pbf
3308: , pay_input_values_f piv
3309: , pay_element_types_f pet
3310: , pay_element_entries_f pee
3311: , pay_element_links_f pel
3312: , per_all_people_f pap
3313: , per_periods_of_service pps

Line 3328: from pay_element_types_f et

3324: and paa.period_of_service_id = pps.period_of_service_id
3325: and pbt.balance_name = 'Union Fees'
3326: and pbt.legislation_code = g_legislation_code
3327: and pet.effective_start_date = (select max(et.effective_start_date )
3328: from pay_element_types_f et
3329: where et.element_type_id= pet.element_type_id
3330: and c_fw_period_end between pet.effective_Start_date and pet.effective_end_date
3331: );
3332:

Line 3367: l_reporting_name pay_element_types_f.reporting_name%type;

3363: idx number;
3364: t_union_bal_sort tab_au_eoy_bal_type := tab_au_eoy_bal_type();
3365: counter number;
3366: ix number;
3367: l_reporting_name pay_element_types_f.reporting_name%type;
3368: l_2006_union_setup_found boolean := false;
3369: l_union_count number;
3370: l_total_value number;
3371: l_4_value number;

Line 4441: from pay_element_types_f pet

4437: select prv.result_value
4438: ,ppa.payroll_action_id
4439: ,pac.assignment_action_id
4440: ,ppa.effective_date
4441: from pay_element_types_f pet
4442: ,pay_input_values_f piv
4443: ,per_all_assignments_f paa
4444: ,pay_run_results prr
4445: ,pay_run_result_values prv

Line 4647: from pay_element_types_f pet

4643: select distinct nvl(pbt.reporting_name, pbt.balance_name) balance_name
4644: , pay_balance_pkg.get_value(pdb.defined_balance_id, p_max_assignment_action_id, p_registered_employer,null,null,null,null) balance_value
4645: , pdb.defined_balance_id def_id
4646: , pbt.balance_type_id bal_type_id
4647: from pay_element_types_f pet
4648: , per_all_assignments_f paa
4649: , pay_balance_types pbt
4650: , pay_defined_balances pdb
4651: , pay_payroll_actions ppa

Line 4938: , pay_element_types_f pet

4934: , pet.element_information1
4935: from pay_balance_types pbt
4936: , pay_balance_feeds_f pbf
4937: , pay_input_values_f piv
4938: , pay_element_types_f pet
4939: , pay_element_entries_f pee
4940: , pay_element_links_f pel
4941: , per_all_people_f pap
4942: , per_periods_of_service pps

Line 4957: from pay_element_types_f et

4953: and paa.period_of_service_id = pps.period_of_service_id
4954: and pbt.balance_name = 'Union Fees'
4955: and pbt.legislation_code = g_legislation_code
4956: and pet.effective_start_date = (select max(et.effective_start_date )
4957: from pay_element_types_f et
4958: where et.element_type_id= pet.element_type_id
4959: and nvl(pps.actual_termination_date,c_year_end)
4960: between pet.effective_Start_date and pet.effective_end_date
4961: );

Line 4978: l_reporting_name pay_element_types_f.reporting_name%type;

4974: AND pbt.balance_type_id = pdb.balance_type_id
4975: AND pbd.balance_dimension_id = pdb.balance_dimension_id
4976: AND pbd.dimension_name = '_ASG_LE_YTD'; --2610141*/
4977:
4978: l_reporting_name pay_element_types_f.reporting_name%type;
4979: l_procedure constant varchar2(80) := g_package || '.archive_union_name';
4980: l_element_information_category pay_element_types_f.element_information_category%type;
4981: l_element_information1 pay_element_types_f.element_information1%type;
4982: l_count number := 0;

Line 4980: l_element_information_category pay_element_types_f.element_information_category%type;

4976: AND pbd.dimension_name = '_ASG_LE_YTD'; --2610141*/
4977:
4978: l_reporting_name pay_element_types_f.reporting_name%type;
4979: l_procedure constant varchar2(80) := g_package || '.archive_union_name';
4980: l_element_information_category pay_element_types_f.element_information_category%type;
4981: l_element_information1 pay_element_types_f.element_information1%type;
4982: l_count number := 0;
4983: l_2006_union_setup_found boolean;
4984: --

Line 4981: l_element_information1 pay_element_types_f.element_information1%type;

4977:
4978: l_reporting_name pay_element_types_f.reporting_name%type;
4979: l_procedure constant varchar2(80) := g_package || '.archive_union_name';
4980: l_element_information_category pay_element_types_f.element_information_category%type;
4981: l_element_information1 pay_element_types_f.element_information1%type;
4982: l_count number := 0;
4983: l_2006_union_setup_found boolean;
4984: --
4985: begin

Line 5172: pay_element_types_f pet,

5168: ,decode(pps.pds_information1, 'AU_D',nvl(pps.pds_information11,'000 000 000'),pev.screen_entry_value) etp_death_benefit_tfn /*Bug#8315198*/
5169: from hr_organization_information hoi,
5170: hr_organization_units hou,
5171: hr_soft_coding_keyflex hsc,
5172: pay_element_types_f pet,
5173: pay_input_values_f piv,
5174: pay_element_links_f pel,
5175: pay_element_entries_f pee,
5176: pay_element_entry_values_f pev,

Line 5238: from pay_element_types_f pet

5234: cursor etp_trans_paid_flags(c_assignment_id per_all_Assignments_f.assignment_id%type,
5235: c_year_start date ,
5236: c_year_end date ) IS
5237: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
5238: from pay_element_types_f pet
5239: ,pay_input_values_f piv
5240: ,per_all_assignments_f paa
5241: ,pay_run_results prr
5242: ,pay_run_result_values prv

Line 6001: ,pay_element_types_f pet

5997: ,per_all_assignments_f paaf
5998: ,pay_assignment_actions pac
5999: ,pay_payroll_actions ppa
6000: ,pay_payrolls_f papf
6001: ,pay_element_types_f pet
6002: WHERE pac.assignment_id = p_assignment_id
6003: AND pac.assignment_action_id = prr.assignment_action_id
6004: AND pac.tax_unit_id = p_registered_employer
6005: AND pac.assignment_id = paaf.assignment_id

Line 7249: pay_element_types_f pet,

7245: c_date_earned pay_payroll_actions.date_earned%TYPE)
7246: is
7247: select pev.screen_entry_value tfn_no
7248: from
7249: pay_element_types_f pet,
7250: pay_input_values_f piv,
7251: pay_element_links_f pel,
7252: pay_element_entries_f pee,
7253: pay_element_entry_values_f pev

Line 8279: pay_element_types_f pet,

8275: SELECT max(ppa.effective_date) effective_date
8276: FROM pay_assignment_actions paa,
8277: pay_payroll_actions ppa,
8278: per_assignments_f paf,
8279: pay_element_types_f pet,
8280: pay_run_results prr
8281: WHERE paa.assignment_id = paf.assignment_id
8282: AND paf.assignment_id = c_assignment_id
8283: AND ppa.payroll_action_id = paa.payroll_action_id

Line 9653: ,pay_element_types_f pet

9649: ,pay_payroll_actions ppa
9650: ,pay_element_entries_f pee
9651: ,pay_run_results prr
9652: ,pay_run_result_values prv
9653: ,pay_element_types_f pet
9654: ,pay_input_values_f piv
9655: ,pay_element_classifications pec
9656: WHERE paa.assignment_id = p_assignment_id
9657: AND pps.PERIOD_OF_SERVICE_ID = paa.PERIOD_OF_SERVICE_ID