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 419: pay_assignment_actions paas1,

415: AND paas.payroll_action_id=ppa.payroll_action_id
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

Line 455: pay_assignment_actions paas,

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

Line 470: pay_assignment_actions paas1,

466: AND paas.payroll_action_id=ppa.payroll_action_id
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

Line 506: pay_assignment_actions paas,

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

Line 521: pay_assignment_actions paas1,

517: AND paas.payroll_action_id=ppa.payroll_action_id
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