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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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:
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 ;
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;
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);