[Home] [Help]
769: cursor c_sel1 is
770: select pee.entry_type,
771: pet.processing_type
772: from pay_element_types_f pet,
773: pay_element_links_f pel,
774: pay_element_entries_f pee
775: where pee.element_entry_id = p_base_key_value
776: and p_effective_date between pee.effective_start_date
777: and pee.effective_end_date
857: pee.element_link_id,
858: pee.entry_type,
859: pet.processing_type
860: from pay_element_types_f pet,
861: pay_element_links_f pel,
862: pay_element_entries_f pee
863: where pee.element_entry_id = p_base_key_value
864: and p_effective_date between pee.effective_start_date
865: and pee.effective_end_date
907: p_base_key_value => p_base_key_value,
908: p_parent_table_name1 => 'per_all_assignments_f',
909: p_parent_key_column1 => 'assignment_id',
910: p_parent_key_value1 => l_parent_key_value1,
911: p_parent_table_name2 => 'pay_element_links_f',
912: p_parent_key_column2 => 'element_link_id',
913: p_parent_key_value2 => l_parent_key_value2,
914: p_zap => p_zap,
915: p_delete => p_delete,
962: p_base_key_value => p_rec.element_entry_id,
963: p_parent_table_name1 => 'per_all_assignments_f',
964: p_parent_key_column1 => 'assignment_id',
965: p_parent_key_value1 => p_rec.assignment_id,
966: p_parent_table_name2 => 'pay_element_links_f',
967: p_parent_key_column2 => 'element_link_id',
968: p_parent_key_value2 => p_rec.element_link_id,
969: p_enforce_foreign_locking => true,
970: p_validation_start_date => l_validation_start_date,
1082: p_base_key_value => p_element_entry_id,
1083: p_parent_table_name1 => 'per_all_assignments_f',
1084: p_parent_key_column1 => 'assignment_id',
1085: p_parent_key_value1 => g_old_rec.assignment_id,
1086: p_parent_table_name2 => 'pay_element_links_f',
1087: p_parent_key_column2 => 'element_link_id',
1088: p_parent_key_value2 => g_old_rec.element_link_id,
1089: p_enforce_foreign_locking => true,
1090: p_validation_start_date => l_validation_start_date,