[Home] [Help]
766: cursor c_sel1 is
767: select pee.entry_type,
768: pet.processing_type
769: from pay_element_types_f pet,
770: pay_element_links_f pel,
771: pay_element_entries_f pee
772: where pee.element_entry_id = p_base_key_value
773: and p_effective_date between pee.effective_start_date
774: and pee.effective_end_date
854: pee.element_link_id,
855: pee.entry_type,
856: pet.processing_type
857: from pay_element_types_f pet,
858: pay_element_links_f pel,
859: pay_element_entries_f pee
860: where pee.element_entry_id = p_base_key_value
861: and p_effective_date between pee.effective_start_date
862: and pee.effective_end_date
904: p_base_key_value => p_base_key_value,
905: p_parent_table_name1 => 'per_all_assignments_f',
906: p_parent_key_column1 => 'assignment_id',
907: p_parent_key_value1 => l_parent_key_value1,
908: p_parent_table_name2 => 'pay_element_links_f',
909: p_parent_key_column2 => 'element_link_id',
910: p_parent_key_value2 => l_parent_key_value2,
911: p_zap => p_zap,
912: p_delete => p_delete,
959: p_base_key_value => p_rec.element_entry_id,
960: p_parent_table_name1 => 'per_all_assignments_f',
961: p_parent_key_column1 => 'assignment_id',
962: p_parent_key_value1 => p_rec.assignment_id,
963: p_parent_table_name2 => 'pay_element_links_f',
964: p_parent_key_column2 => 'element_link_id',
965: p_parent_key_value2 => p_rec.element_link_id,
966: p_enforce_foreign_locking => true,
967: p_validation_start_date => l_validation_start_date,
1079: p_base_key_value => p_element_entry_id,
1080: p_parent_table_name1 => 'per_all_assignments_f',
1081: p_parent_key_column1 => 'assignment_id',
1082: p_parent_key_value1 => g_old_rec.assignment_id,
1083: p_parent_table_name2 => 'pay_element_links_f',
1084: p_parent_key_column2 => 'element_link_id',
1085: p_parent_key_value2 => g_old_rec.element_link_id,
1086: p_enforce_foreign_locking => true,
1087: p_validation_start_date => l_validation_start_date,