DBA Data[Home] [Help]

APPS.PAY_IE_BIK dependencies on PAY_RUN_RESULTS

Line 405: pay_run_results prr,

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
407: where pee.element_entry_id=p_element_entry_id
408: AND prr.source_id = pee.element_entry_id
409: AND prr.element_type_id=pet.element_type_id

Line 420: pay_run_results prr1,

416: AND paas.assignment_id=pee.assignment_id
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

Line 456: pay_run_results prr,

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
458: where pee.element_entry_id=p_element_entry_id
459: AND prr.source_id = pee.element_entry_id
460: AND prr.element_type_id=pet.element_type_id

Line 471: pay_run_results prr1,

467: AND paas.assignment_id=pee.assignment_id
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

Line 507: pay_run_results prr,

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
509: where pee.element_entry_id=p_element_entry_id
510: AND prr.source_id = pee.element_entry_id
511: AND prr.element_type_id=pet.element_type_id

Line 522: pay_run_results prr1,

518: AND paas.assignment_id=pee.assignment_id
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