[Home] [Help]
710: Cursor C_Sel1 Is
711: select pee.entry_type,
712: pet.processing_type
713: from pay_element_types_f pet,
714: pay_element_links_f pel,
715: pay_element_entries_f pee
716: where pee.element_entry_id = p_base_key_value
717: and p_effective_date
718: between pee.effective_start_date and pee.effective_end_date
789: pee.element_link_id,
790: pee.entry_type,
791: pet.processing_type
792: from pay_element_types_f pet,
793: pay_element_links_f pel,
794: pay_element_entries_f pee
795: where pee.element_entry_id = p_base_key_value
796: and p_effective_date
797: between pee.effective_start_date and pee.effective_end_date
835: p_base_key_value => p_base_key_value,
836: p_parent_table_name1 => 'per_all_assignments_f',
837: p_parent_key_column1 => 'assignment_id',
838: p_parent_key_value1 => l_parent_key_value1,
839: p_parent_table_name2 => 'pay_element_links_f',
840: p_parent_key_column2 => 'element_link_id',
841: p_parent_key_value2 => l_parent_key_value2,
842: p_zap => p_zap,
843: p_delete => p_delete,
881: p_base_key_value => p_rec.element_entry_id,
882: p_parent_table_name1 => 'per_all_assignments_f',
883: p_parent_key_column1 => 'assignment_id',
884: p_parent_key_value1 => p_rec.assignment_id,
885: p_parent_table_name2 => 'pay_element_links_f',
886: p_parent_key_column2 => 'element_link_id',
887: p_parent_key_value2 => p_rec.element_link_id,
888: p_enforce_foreign_locking => true,
889: p_validation_start_date => l_validation_start_date,
1027: p_base_key_value => p_element_entry_id,
1028: p_parent_table_name1 => 'per_all_assignments_f',
1029: p_parent_key_column1 => 'assignment_id',
1030: p_parent_key_value1 => g_old_rec.assignment_id,
1031: p_parent_table_name2 => 'pay_element_links_f',
1032: p_parent_key_column2 => 'element_link_id',
1033: p_parent_key_value2 => g_old_rec.element_link_id,
1034: p_enforce_foreign_locking => true,
1035: p_validation_start_date => l_validation_start_date,