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 421: pay_element_entries_f pee1

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

Line 453: pay_element_entries_f pee,

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

Line 472: pay_element_entries_f pee1

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

Line 504: pay_element_entries_f pee,

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

Line 523: pay_element_entries_f pee1

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