DBA Data[Home] [Help]

APPS.PAY_IE_BIK dependencies on PAY_ASSIGNMENT_ACTIONS

Line 404: pay_assignment_actions paas,

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

Line 420: pay_assignment_actions paas1,

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

Line 456: pay_assignment_actions paas,

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

Line 472: pay_assignment_actions paas1,

468: AND paas.payroll_action_id=ppa.payroll_action_id
469: AND paas.assignment_id=pee.assignment_id
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

Line 508: pay_assignment_actions paas,

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
511: where pee.element_entry_id=p_element_entry_id
512: AND prr.source_id = pee.element_entry_id

Line 524: pay_assignment_actions paas1,

520: AND paas.payroll_action_id=ppa.payroll_action_id
521: AND paas.assignment_id=pee.assignment_id
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