[Home] [Help]
726: Cursor C_Sel1 Is
727: select pee.entry_type,
728: pet.processing_type
729: from pay_element_types_f pet,
730: pay_element_links_f pel,
731: pay_element_entries_f pee
732: where pee.element_entry_id = p_base_key_value
733: and p_effective_date
734: between pee.effective_start_date and pee.effective_end_date
805: pee.element_link_id,
806: pee.entry_type,
807: pet.processing_type
808: from pay_element_types_f pet,
809: pay_element_links_f pel,
810: pay_element_entries_f pee
811: where pee.element_entry_id = p_base_key_value
812: and p_effective_date
813: between pee.effective_start_date and pee.effective_end_date
851: p_base_key_value => p_base_key_value,
852: p_parent_table_name1 => 'per_all_assignments_f',
853: p_parent_key_column1 => 'assignment_id',
854: p_parent_key_value1 => l_parent_key_value1,
855: p_parent_table_name2 => 'pay_element_links_f',
856: p_parent_key_column2 => 'element_link_id',
857: p_parent_key_value2 => l_parent_key_value2,
858: p_zap => p_zap,
859: p_delete => p_delete,
897: p_base_key_value => p_rec.element_entry_id,
898: p_parent_table_name1 => 'per_all_assignments_f',
899: p_parent_key_column1 => 'assignment_id',
900: p_parent_key_value1 => p_rec.assignment_id,
901: p_parent_table_name2 => 'pay_element_links_f',
902: p_parent_key_column2 => 'element_link_id',
903: p_parent_key_value2 => p_rec.element_link_id,
904: p_enforce_foreign_locking => true,
905: p_validation_start_date => l_validation_start_date,
1043: p_base_key_value => p_element_entry_id,
1044: p_parent_table_name1 => 'per_all_assignments_f',
1045: p_parent_key_column1 => 'assignment_id',
1046: p_parent_key_value1 => g_old_rec.assignment_id,
1047: p_parent_table_name2 => 'pay_element_links_f',
1048: p_parent_key_column2 => 'element_link_id',
1049: p_parent_key_value2 => g_old_rec.element_link_id,
1050: p_enforce_foreign_locking => true,
1051: p_validation_start_date => l_validation_start_date,