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

Line 650: FROM pay_element_entries_f pee

646: attribute18,
647: attribute19,
648: attribute20,
649: label_identifier
650: FROM pay_element_entries_f pee
651: WHERE pee.element_entry_id = p_element_entry_id
652: AND p_eff_dt BETWEEN pee.effective_start_date
653: AND pee.effective_end_date;
654:

Line 655: l_original_entry_id pay_element_entries_f.original_entry_id%TYPE;

651: WHERE pee.element_entry_id = p_element_entry_id
652: AND p_eff_dt BETWEEN pee.effective_start_date
653: AND pee.effective_end_date;
654:
655: l_original_entry_id pay_element_entries_f.original_entry_id%TYPE;
656: l_entry_type pay_element_entries_f.entry_type%TYPE;
657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;
658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;

Line 656: l_entry_type pay_element_entries_f.entry_type%TYPE;

652: AND p_eff_dt BETWEEN pee.effective_start_date
653: AND pee.effective_end_date;
654:
655: l_original_entry_id pay_element_entries_f.original_entry_id%TYPE;
656: l_entry_type pay_element_entries_f.entry_type%TYPE;
657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;
658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;

Line 657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;

653: AND pee.effective_end_date;
654:
655: l_original_entry_id pay_element_entries_f.original_entry_id%TYPE;
656: l_entry_type pay_element_entries_f.entry_type%TYPE;
657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;
658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;

Line 658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;

654:
655: l_original_entry_id pay_element_entries_f.original_entry_id%TYPE;
656: l_entry_type pay_element_entries_f.entry_type%TYPE;
657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;
658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;

Line 659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;

655: l_original_entry_id pay_element_entries_f.original_entry_id%TYPE;
656: l_entry_type pay_element_entries_f.entry_type%TYPE;
657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;
658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;

Line 660: l_comment_id pay_element_entries_f.comment_id%TYPE;

656: l_entry_type pay_element_entries_f.entry_type%TYPE;
657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;
658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;

Line 661: l_reason pay_element_entries_f.reason%TYPE;

657: l_cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE;
658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;

Line 662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;

658: l_updating_action_id pay_element_entries_f.updating_action_id%TYPE;
659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;

Line 663: l_subpriority pay_element_entries_f.subpriority%TYPE;

659: l_updating_action_type pay_element_entries_f.updating_action_type%TYPE;
660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;

Line 664: l_date_earned pay_element_entries_f.date_earned%TYPE;

660: l_comment_id pay_element_entries_f.comment_id%TYPE;
661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;

Line 665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;

661: l_reason pay_element_entries_f.reason%TYPE;
662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;

Line 666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;

662: l_target_entry_id pay_element_entries_f.target_entry_id%TYPE;
663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;

Line 667: l_attribute1 pay_element_entries_f.attribute1%TYPE;

663: l_subpriority pay_element_entries_f.subpriority%TYPE;
664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;

Line 668: l_attribute2 pay_element_entries_f.attribute2%TYPE;

664: l_date_earned pay_element_entries_f.date_earned%TYPE;
665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;

Line 669: l_attribute3 pay_element_entries_f.attribute3%TYPE;

665: l_personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE;
666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;

Line 670: l_attribute4 pay_element_entries_f.attribute4%TYPE;

666: l_attribute_category pay_element_entries_f.attribute_category%TYPE;
667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;

Line 671: l_attribute5 pay_element_entries_f.attribute5%TYPE;

667: l_attribute1 pay_element_entries_f.attribute1%TYPE;
668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;

Line 672: l_attribute6 pay_element_entries_f.attribute6%TYPE;

668: l_attribute2 pay_element_entries_f.attribute2%TYPE;
669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;

Line 673: l_attribute7 pay_element_entries_f.attribute7%TYPE;

669: l_attribute3 pay_element_entries_f.attribute3%TYPE;
670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;

Line 674: l_attribute8 pay_element_entries_f.attribute8%TYPE;

670: l_attribute4 pay_element_entries_f.attribute4%TYPE;
671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;

Line 675: l_attribute9 pay_element_entries_f.attribute9%TYPE;

671: l_attribute5 pay_element_entries_f.attribute5%TYPE;
672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;

Line 676: l_attribute10 pay_element_entries_f.attribute10%TYPE;

672: l_attribute6 pay_element_entries_f.attribute6%TYPE;
673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;

Line 677: l_attribute11 pay_element_entries_f.attribute11%TYPE;

673: l_attribute7 pay_element_entries_f.attribute7%TYPE;
674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;

Line 678: l_attribute12 pay_element_entries_f.attribute12%TYPE;

674: l_attribute8 pay_element_entries_f.attribute8%TYPE;
675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;

Line 679: l_attribute13 pay_element_entries_f.attribute13%TYPE;

675: l_attribute9 pay_element_entries_f.attribute9%TYPE;
676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;

Line 680: l_attribute14 pay_element_entries_f.attribute14%TYPE;

676: l_attribute10 pay_element_entries_f.attribute10%TYPE;
677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;

Line 681: l_attribute15 pay_element_entries_f.attribute15%TYPE;

677: l_attribute11 pay_element_entries_f.attribute11%TYPE;
678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;
685: l_attribute19 pay_element_entries_f.attribute19%TYPE;

Line 682: l_attribute16 pay_element_entries_f.attribute16%TYPE;

678: l_attribute12 pay_element_entries_f.attribute12%TYPE;
679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;
685: l_attribute19 pay_element_entries_f.attribute19%TYPE;
686: l_attribute20 pay_element_entries_f.attribute20%TYPE;

Line 683: l_attribute17 pay_element_entries_f.attribute17%TYPE;

679: l_attribute13 pay_element_entries_f.attribute13%TYPE;
680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;
685: l_attribute19 pay_element_entries_f.attribute19%TYPE;
686: l_attribute20 pay_element_entries_f.attribute20%TYPE;
687: l_label_identifier pay_element_entries_f.label_identifier%TYPE;

Line 684: l_attribute18 pay_element_entries_f.attribute18%TYPE;

680: l_attribute14 pay_element_entries_f.attribute14%TYPE;
681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;
685: l_attribute19 pay_element_entries_f.attribute19%TYPE;
686: l_attribute20 pay_element_entries_f.attribute20%TYPE;
687: l_label_identifier pay_element_entries_f.label_identifier%TYPE;
688:

Line 685: l_attribute19 pay_element_entries_f.attribute19%TYPE;

681: l_attribute15 pay_element_entries_f.attribute15%TYPE;
682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;
685: l_attribute19 pay_element_entries_f.attribute19%TYPE;
686: l_attribute20 pay_element_entries_f.attribute20%TYPE;
687: l_label_identifier pay_element_entries_f.label_identifier%TYPE;
688:
689: l_rtr_ee_cntr_ele_link_id number;

Line 686: l_attribute20 pay_element_entries_f.attribute20%TYPE;

682: l_attribute16 pay_element_entries_f.attribute16%TYPE;
683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;
685: l_attribute19 pay_element_entries_f.attribute19%TYPE;
686: l_attribute20 pay_element_entries_f.attribute20%TYPE;
687: l_label_identifier pay_element_entries_f.label_identifier%TYPE;
688:
689: l_rtr_ee_cntr_ele_link_id number;
690:

Line 687: l_label_identifier pay_element_entries_f.label_identifier%TYPE;

683: l_attribute17 pay_element_entries_f.attribute17%TYPE;
684: l_attribute18 pay_element_entries_f.attribute18%TYPE;
685: l_attribute19 pay_element_entries_f.attribute19%TYPE;
686: l_attribute20 pay_element_entries_f.attribute20%TYPE;
687: l_label_identifier pay_element_entries_f.label_identifier%TYPE;
688:
689: l_rtr_ee_cntr_ele_link_id number;
690:
691: l_prev_entry_start_date date ;

Line 841: update pay_element_entries_f

837:
838: hr_utility.trace('Prev entry Start Date:'||to_char(l_prev_entry_start_date));
839: hr_utility.trace('Prev entry End Date:'||to_char(l_prev_entry_end_date));
840:
841: update pay_element_entries_f
842: set source_asg_action_id = p_assact_id
843: ,source_start_date = l_prev_entry_start_date
844: ,source_end_date = l_prev_entry_end_date
845: where element_entry_id = l_element_entry_id;

Line 1100: from pay_element_entries_f

1096: -- Check if retro entries have already been created
1097: -- which would mean that the customer has already run the process
1098: select count(1)
1099: into l_process_run_count
1100: from pay_element_entries_f
1101: where source_asg_action_id = l_assact_id
1102: and element_type_id in (l_retro_ee_contr_ele_type_id,
1103: l_retro_er_contr_ele_type_id,
1104: l_retro_excs_er_cntr_ele_tp_id);