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_IE_BIK dependencies on PAY_ELEMENT_ENTRIES_F

Line 402: pay_element_entries_f pee,

398: p_curr_period_start_date in DATE) is
399: select nvl(sum(to_number(prrv.result_value)),0)
400: from pay_element_types_f pet,
401: pay_input_values_f piv,
402: pay_element_entries_f pee,
403: pay_payroll_actions ppa,
404: pay_assignment_actions paas,
405: pay_run_results prr,
406: pay_run_result_values prrv

Line 422: pay_element_entries_f pee1

418: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
419: from pay_payroll_actions ppa1,
420: pay_assignment_actions paas1,
421: pay_run_results prr1,
422: pay_element_entries_f pee1
423: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)
424: AND pee1.element_entry_id=p_element_entry_id
425: AND prr1.element_entry_id = pee1.element_entry_id
426: AND paas1.assignment_action_id=prr1.assignment_action_id

Line 454: pay_element_entries_f pee,

450: p_curr_period_start_date in DATE) is
451: select nvl(sum(to_number(prrv.result_value)),0)
452: from pay_element_types_f pet,
453: pay_input_values_f piv,
454: pay_element_entries_f pee,
455: pay_payroll_actions ppa,
456: pay_assignment_actions paas,
457: pay_run_results prr,
458: pay_run_result_values prrv

Line 474: pay_element_entries_f pee1

470: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
471: from pay_payroll_actions ppa1,
472: pay_assignment_actions paas1,
473: pay_run_results prr1,
474: pay_element_entries_f pee1
475: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)
476: AND pee1.element_entry_id=p_element_entry_id
477: AND prr1.element_entry_id = pee1.element_entry_id
478: AND paas1.assignment_action_id=prr1.assignment_action_id

Line 506: pay_element_entries_f pee,

502: p_curr_period_start_date in DATE) is
503: select nvl(sum(to_number(prrv.result_value)),0)
504: from pay_element_types_f pet,
505: pay_input_values_f piv,
506: pay_element_entries_f pee,
507: pay_payroll_actions ppa,
508: pay_assignment_actions paas,
509: pay_run_results prr,
510: pay_run_result_values prrv

Line 526: pay_element_entries_f pee1

522: AND ppa.date_earned>( select min(ppa1.date_earned) -- query is now based on date earned (5070091)
523: from pay_payroll_actions ppa1,
524: pay_assignment_actions paas1,
525: pay_run_results prr1,
526: pay_element_entries_f pee1
527: where ppa1.date_earned>=p_vehicle_alloc_end_date -- query is now based on date earned (5070091)
528: AND pee1.element_entry_id=p_element_entry_id
529: AND prr1.element_entry_id = pee1.element_entry_id
530: AND paas1.assignment_action_id=prr1.assignment_action_id